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