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