New to Access: Question about creating a form that has information from multiple Tables/Queries

[ComeOnYouSpurs]

Hi all,

I am creating a database for some reporting information. I have created multiple tables and queries with the information I need to be on my form. The information needed is based on a Client Name such as XYZ Trading LLC. When this is selected on a form (from a drop down menu perhaps?) , is it possible to have the relative information from other tables and queries show up? If possible what must I do to facilitate a form of such nature. Please let me know if you need anymore information to answer the question. I am new to Access and am learning as I go.

Thank you so much for all your help!

Cheers,

COYS

 

[ranman256]

Usu you just build a query that pulls all info needed then display it.
Or
you can pull the main data into a query/form. Then show satellite info using subForms.