Query/Form Question

[Andy]

Hi,

I have a single table inventory with several names, some of the names are on
several records relating to several orders

I know it is possible to have a query with will return all products under
that name

Is it possible to create a form which will return the query depending on the
current name in the name field, i.e, so when the record changes to another
name, all the corresponding products for this next name will be listed?

Thank you for any help

Andy

 

[Guest]

Use a main form for name and a subform for orders.
The Master/Child links would be on the name.