Subject | Multiple Queries |
---|---|
Author | Daniel Miller |
Post date | 2001-07-18T15:07:02Z |
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]
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]