Lookup Code

[wildexodus]

I have a table (tblOrderDetails) with a foreign key in it (ProductID) which i am using to lookup up data from another table. So far in the Row source of the lookup ive got the following code:

SELECT DISTINCTROW [ProductID], [ProductName] FROM tblProducts;

I want to also display the Product Type. In tblProducts there is a foreign key (ProductTypeID) which i am using in this table to list all the product types. What i need is for the product types to also be displayed in a column of the combo box for the lookup mentioned above.

Is this possible?

 

[Rob.Mills]

Unfortunately I don't have access to zip software at work so I'm not able to look at your db. But what I think might help you is an auto-lookup query. Look that up in the help files it gives a great description on how to make one.