How To Link Forms?

[Guest]

I have a database with several Tables that feed different Forms. For example,
I have Persons Form with biographical data (ID, name, offices served, etc.)
and I have a Offices Form with institutional information (ID, type of office,
category, place where it is served, persons who served, etc.). Of course,
those tables are relate to each other.
My question is: is it possible to link those two forms in a way that when
I'm viewing the Persons Form and I click on an office he had served, Access
wil open the Offices Form in the proper record?

 

[Guest]

Open Persons Form in design view and from the toolbar select Subform. Use
the Offices Form as the sub form

Ensure that some where on both forms you have a linkinf control/field (could
be the Persons ID).

Link the forms with the ID and when you select a person on the main form the
subform will show the inforrmation you need.

Good luck

 

[Guest]

Thank you for your answer. In fact I already use the subform system because
this is a one-to-many relationship (one person may have served several
offices, so the Persons Form has a subform with the offices served by that
person). But what I would need was a different thing. I would like to be able
to click on an office from the list that person had served and to open The
Offices Form with the information on that specific office.

Using a common example :

A Clients Form, a products Form and an Orders Form.
In the Clients Form I have a Subform with the products that client has
ordered; In the Products Form I have the clients that have order that product.
Is it possible to tell Acces that a click on a item from, lets say, the
Products Subform on the Clients Form would open the Products Form on that
specific record?

thanks in advance,
Nuno