Subject Multiple Queries
Author Daniel Miller
Using the lookupcombos in grids, can I have multiple occurences of the same table? If I'm trying to describe a relationship:

PARTS
Part_Id
Part_No

RELATIONSHIPS
Master_Part_Id
Child_Part_Id

I create a query for browsing the parts in the upper half of the form, then another for the relationships in the lower half - no problem. But then I want two lookupcombos in the grid, one for the master part and one for the child part. I've tried creating two additional PART queries, and using the Keylinks/KeyDesc as shown in the Company example. The combo boxes don't activate in the grid. How can I do this?

Daniel


[Non-text portions of this message have been removed]