Query that will keep the one to many relationship from the orginal table

[JayRab]

I have the following with a 1 to many relationship and I would like a query to keep that relationship so I can post it in a subform and have the Drop down with the yellow highlighted stuff. So what I would like is the yellow highlight area in my FORM to look like the highlighted area in the Table. Any tips would be helpful. I have tried relationship but i havent been able to get it to work since a query wont let me select one to many. Also I need the query to reduce the data and make sure only OPEN/ACTIVE items are displayed.

thanks for any help

[June7]

You have two forms set as Datasheet view and you want one dependent on the other?

It is possible to nest forms and get the appearance of the nested tables, at least I have seen it but never used.

Otherwise, review: http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp