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: [email protected]
For additional commands, e-mail: [email protected]
