One To Many Record Display while in a Forms Env.

[CementCarver]

I have a database that links tables via a member_id auto number and I've created multiple forms depending on what type of data is meant to display. But I have a situation where this one form, now branches out to be a one to many relationship and I was hoping to display this one to many relationship linked to a main form, but as a subgroup.



So, right now, if the user selects a company to review, they can select the company name, and then select a command box to display the appropriate companies product line. But once the user selects this product line, it then becomes a one to many display, and I am wondering what's the best way to then break out to display a one to many forms environment?

CementCarver

[orange]

Please post a jpg of your tables and relationships.

[CementCarver]

Thx Orange, but I just solved my own problem.