Recurring problem with forms

[Keith Clark-2]

I keep having the same issues that I always have to stumble upon the
solution.

I have two tables.

Table1

ProductID          INT    Primary Key
ProductName        Text
ProductCategory    INT

Table2

ProductCategoryID   INT    Primary Key
CategoryName        Text
CategoryDescription Text

Now, I want to create a form to enter date into the first table, Table1.
I want to link ProductCategory from Table1 to ProductCategoryID from
Table2, but I just want to show the user the CategoryName from Table2.

I'm never sure how I do this and I usually just keep poking away until I
stumble upon it and never learn anything.

Any help would be appreciated.

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

> Now, I want to create a form to enter date into the first table, Table1.
> I want to link ProductCategory from Table1 to ProductCategoryID from
> Table2, but I just want to show the user the CategoryName from Table2.
>
> I'm never sure how I do this and I usually just keep poking away until I
> stumble upon it and never learn anything.
>
> Any help would be appreciated.
>
> Keith

Sorry, this should have been:

Now, I want to create a form to enter DATA....

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Fred Frazelle-2]

Keith Clark wrote:

> I keep having the same issues that I always have to stumble upon the
> solution.
>
> I have two tables.
>
> Table1
>
> ProductID          INT    Primary Key
> ProductName        Text
> ProductCategory    INT
>
> Table2
>
> ProductCategoryID   INT    Primary Key
> CategoryName        Text
> CategoryDescription Text
>
> Now, I want to create a form to enter date into the first table, Table1.
> I want to link ProductCategory from Table1 to ProductCategoryID from
> Table2, but I just want to show the user the CategoryName from Table2.
>
> I'm never sure how I do this and I usually just keep poking away until I
> stumble upon it and never learn anything.
>
> Any help would be appreciated.
>
> Keith
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>
>
>  

Keith, since you've only got 2 tables and one depends on the other, you
might as well just use the Form Wizard and use the Sub-form.  Once
you've got it pretty well set up, you can Hide the Controls you like or
you can delete them completely.

  You also might consider the possibility of starting some sort of text
document with the tips you discover as you go along.  That's what i've
taken to doing since it also happens to me.  i sometimes go a year
between having to create a new database and by then all that info is
just... history.  i'm using OpenOffice and its ability to create
Bookmarks within a document so i can create a simple index at the
beginning and link to the bookmarks within the doc.  Eventually this
memory thing will probably get so bad i'll forget that i created the
document, what i named it or where it's hidden -- lol !

    Have a great evening!  :) , fred

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Drew Jensen]

Keith Clark wrote:

> I keep having the same issues that I always have to stumble upon the
> solution.
>
> I have two tables.
>
> Table1
>
> ProductID          INT    Primary Key
> ProductName        Text
> ProductCategory    INT
>
> Table2
>
> ProductCategoryID   INT    Primary Key
> CategoryName        Text
> CategoryDescription Text
>
> Now, I want to create a form to enter date into the first table, Table1.
> I want to link ProductCategory from Table1 to ProductCategoryID from
> Table2, but I just want to show the user the CategoryName from Table2.
>
> I'm never sure how I do this and I usually just keep poking away until I
> stumble upon it and never learn anything.
>
> Any help would be appreciated.
>
> Keith
>  

Hello Keith,

What you are looking for is the ListBox control.

You can add this control type to your form one of two ways.

1) [You used the form wizard to create a form based on Table1]
Select the TextBox control that was assigned to the column ProductCategory.
Tip - Ffor me, the easiest way  is to open the DataForm Navigator (found
on the Form Design toolbar]. This navigator window lets you select one
or more controls, by name, using the mouse.
Now right click the control and select 'Replace with...' from the
context menu - select List Box.
Open the property editor for the ListBox control.
The Data tab will show that the control is still assigned to
ProductCategory as "Data Field"
Change the type of list context from ValueList to one of Table, Query,
SQL...etc. as needed.

2) When creating or adding columns to a form by hand.
With the form open in Edit mode - select the List Box control from the
Form Controls toolbar.
Use the mouse to draw where you want the ListBox control on the form -
the List Box Wizard starts.
Tip - My translation of the first page of that dialog > You pick the
table from which the display data will come first... L>)

HTH

Drew

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

On Wed, 2009-09-30 at 03:52 -0400, Drew Jensen wrote:

> Keith Clark wrote:
> > I keep having the same issues that I always have to stumble upon the
> > solution.
> >
> > I have two tables.
> >
> > Table1
> >
> > ProductID          INT    Primary Key
> > ProductName        Text
> > ProductCategory    INT
> >
> > Table2
> >
> > ProductCategoryID   INT    Primary Key
> > CategoryName        Text
> > CategoryDescription Text
> >
> > Now, I want to create a form to enter date into the first table, Table1.
> > I want to link ProductCategory from Table1 to ProductCategoryID from
> > Table2, but I just want to show the user the CategoryName from Table2.
> >
> > I'm never sure how I do this and I usually just keep poking away until I
> > stumble upon it and never learn anything.
> >
> > Any help would be appreciated.
> >
> > Keith
> >  
>
> Hello Keith,
>
> What you are looking for is the ListBox control.
>
> You can add this control type to your form one of two ways.
>
> 1) [You used the form wizard to create a form based on Table1]
> Select the TextBox control that was assigned to the column ProductCategory.
> Tip - Ffor me, the easiest way  is to open the DataForm Navigator (found
> on the Form Design toolbar]. This navigator window lets you select one
> or more controls, by name, using the mouse.
> Now right click the control and select 'Replace with...' from the
> context menu - select List Box.
> Open the property editor for the ListBox control.
> The Data tab will show that the control is still assigned to
> ProductCategory as "Data Field"
> Change the type of list context from ValueList to one of Table, Query,
> SQL...etc. as needed.
>
> 2) When creating or adding columns to a form by hand.
> With the form open in Edit mode - select the List Box control from the
> Form Controls toolbar.
> Use the mouse to draw where you want the ListBox control on the form -
> the List Box Wizard starts.
> Tip - My translation of the first page of that dialog > You pick the
> table from which the display data will come first... L>)
>
> HTH
>

Drew,

Yes, this did help and I can display the contents of a query that way
but how do I select the ProductCategory field value from table2,
ProductCategoryID using the field ProductCategoryName and showing
ProductCategoryDescription?

Thanks,

Keith





---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

On Wed, 2009-09-30 at 23:57 -0400, Keith Clark wrote:

> On Wed, 2009-09-30 at 03:52 -0400, Drew Jensen wrote:
> > Keith Clark wrote:
> > > I keep having the same issues that I always have to stumble upon the
> > > solution.
> > >
> > > I have two tables.
> > >
> > > Table1
> > >
> > > ProductID          INT    Primary Key
> > > ProductName        Text
> > > ProductCategory    INT
> > >
> > > Table2
> > >
> > > ProductCategoryID   INT    Primary Key
> > > CategoryName        Text
> > > CategoryDescription Text
> > >
> > > Now, I want to create a form to enter date into the first table, Table1.
> > > I want to link ProductCategory from Table1 to ProductCategoryID from
> > > Table2, but I just want to show the user the CategoryName from Table2.
> > >
> > > I'm never sure how I do this and I usually just keep poking away until I
> > > stumble upon it and never learn anything.
> > >
> > > Any help would be appreciated.
> > >
> > > Keith
> > >  
> >
> > Hello Keith,
> >
> > What you are looking for is the ListBox control.
> >
> > You can add this control type to your form one of two ways.
> >
> > 1) [You used the form wizard to create a form based on Table1]
> > Select the TextBox control that was assigned to the column ProductCategory.
> > Tip - Ffor me, the easiest way  is to open the DataForm Navigator (found
> > on the Form Design toolbar]. This navigator window lets you select one
> > or more controls, by name, using the mouse.
> > Now right click the control and select 'Replace with...' from the
> > context menu - select List Box.
> > Open the property editor for the ListBox control.
> > The Data tab will show that the control is still assigned to
> > ProductCategory as "Data Field"
> > Change the type of list context from ValueList to one of Table, Query,
> > SQL...etc. as needed.
> >
> > 2) When creating or adding columns to a form by hand.
> > With the form open in Edit mode - select the List Box control from the
> > Form Controls toolbar.
> > Use the mouse to draw where you want the ListBox control on the form -
> > the List Box Wizard starts.
> > Tip - My translation of the first page of that dialog > You pick the
> > table from which the display data will come first... L>)
> >
> > HTH
> >
> Drew,
>
> Yes, this did help and I can display the contents of a query that way
> but how do I select the ProductCategory field value from table2,
> ProductCategoryID using the field ProductCategoryName and showing
> ProductCategoryDescription?
>
> Thanks,
>
> Keith

Ok, never mind Drew and all.  I again stumbled upon it but this time I
wrote myself a little tutorial with screenshots and saved it into my
newly created personal OO.o manual (thanks Fred!!).

Thanks again,

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Fred Frazelle-2]

Keith Clark wrote:

> On Wed, 2009-09-30 at 23:57 -0400, Keith Clark wrote:
>  
>> On Wed, 2009-09-30 at 03:52 -0400, Drew Jensen wrote:
>>    
>>> Keith Clark wrote:
>>>      
>>>> I keep having the same issues that I always have to stumble upon the
>>>> solution.
>>>>
>>>> I have two tables.
>>>>
>>>> Table1
>>>>
>>>> ProductID          INT    Primary Key
>>>> ProductName        Text
>>>> ProductCategory    INT
>>>>
>>>> Table2
>>>>
>>>> ProductCategoryID   INT    Primary Key
>>>> CategoryName        Text
>>>> CategoryDescription Text
>>>>
>>>> Now, I want to create a form to enter date into the first table, Table1.
>>>> I want to link ProductCategory from Table1 to ProductCategoryID from
>>>> Table2, but I just want to show the user the CategoryName from Table2.
>>>>
>>>> I'm never sure how I do this and I usually just keep poking away until I
>>>> stumble upon it and never learn anything.
>>>>
>>>> Any help would be appreciated.
>>>>
>>>> Keith
>>>>  
>>>>        
>>> Hello Keith,
>>>
>>> What you are looking for is the ListBox control.
>>>
>>> You can add this control type to your form one of two ways.
>>>
>>> 1) [You used the form wizard to create a form based on Table1]
>>> Select the TextBox control that was assigned to the column ProductCategory.
>>> Tip - Ffor me, the easiest way  is to open the DataForm Navigator (found
>>> on the Form Design toolbar]. This navigator window lets you select one
>>> or more controls, by name, using the mouse.
>>> Now right click the control and select 'Replace with...' from the
>>> context menu - select List Box.
>>> Open the property editor for the ListBox control.
>>> The Data tab will show that the control is still assigned to
>>> ProductCategory as "Data Field"
>>> Change the type of list context from ValueList to one of Table, Query,
>>> SQL...etc. as needed.
>>>
>>> 2) When creating or adding columns to a form by hand.
>>> With the form open in Edit mode - select the List Box control from the
>>> Form Controls toolbar.
>>> Use the mouse to draw where you want the ListBox control on the form -
>>> the List Box Wizard starts.
>>> Tip - My translation of the first page of that dialog > You pick the
>>> table from which the display data will come first... L>)
>>>
>>> HTH
>>>
>>>      
>> Drew,
>>
>> Yes, this did help and I can display the contents of a query that way
>> but how do I select the ProductCategory field value from table2,
>> ProductCategoryID using the field ProductCategoryName and showing
>> ProductCategoryDescription?
>>
>> Thanks,
>>
>> Keith
>>    
> Ok, never mind Drew and all.  I again stumbled upon it but this time I
> wrote myself a little tutorial with screenshots and saved it into my
> newly created personal OO.o manual (thanks Fred!!).
>
> Thanks again,
>
> Keith
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>
>
>  

You're certainly welcome.  Just tryin' to repay a little...  Have a
great evening!  :) , fred

------------------------------------------------------------------------


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

> >>>> I have two tables.
> >>>>
> >>>> Table1
> >>>>
> >>>> ProductID          INT    Primary Key
> >>>> ProductName        Text
> >>>> ProductCategory    INT
> >>>>
> >>>> Table2
> >>>>
> >>>> ProductCategoryID   INT    Primary Key
> >>>> CategoryName        Text
> >>>> CategoryDescription Text

Ok, I have solved my original problem but now I'm curious about one more
thing.  If I have a list box to choose which entry in Table2 to use in
Table1, but I want to be able to add a new entry in Table2 on the same
form and use that entry.  Is this possible?

Keith




---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

On Thu, 2009-10-01 at 12:55 -0400, Keith Clark wrote:

> > >>>> I have two tables.
> > >>>>
> > >>>> Table1
> > >>>>
> > >>>> ProductID          INT    Primary Key
> > >>>> ProductName        Text
> > >>>> ProductCategory    INT
> > >>>>
> > >>>> Table2
> > >>>>
> > >>>> ProductCategoryID   INT    Primary Key
> > >>>> CategoryName        Text
> > >>>> CategoryDescription Text
>
> Ok, I have solved my original problem but now I'm curious about one more
> thing.  If I have a list box to choose which entry in Table2 to use in
> Table1, but I want to be able to add a new entry in Table2 on the same
> form and use that entry.  Is this possible?
>
> Keith

Ok, I'm part way there.  I can have an in-dependant Table2 on my main
form and display all the tables contents, but I cannot add a record to
it.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...