Table Linking/Relationships

[dL1727]

My question regards 'linking' two tables (i.e. clicking on a value in one table will bring you to that same value in another table). Here is a summary of what I have and what I want to do:

Table 1: Purchase Orders
-This table gives information about a respective purchase order (PO) with each PO having a unique ID (PO_Id), which is set as the key. There are other fields giving more information about the PO, however the number is the only relevant field for what I am aiming for.

Table 2: Payment History
-This table currently has three fields: (1) PO_Id (2) Payment_Amount (3) Payment_Date.

I want the PO_Id which is shared in both tables to act as a link between the two. So when the user is viewing the Purchase Orders table, he/she can click on the PO_Id to easily track its respective Payment History.

Any help would be more than appreciated!

 

[Galaxiom]

Users should not be working in the tables but in forms based on the data in those tables.

Display the first table in a form. Display the second table in a subform on that form.
In the subformcontrol properties, set the Master Link Fields and Child Link Fields as the fields you want to connect.

 

[dL1727]

Right, using a form now makes sense. In regards to the actual form design, can you elaborate on the Master/Child Link Fields. What table would the information then be input into to?

 

[Galaxiom]

Master Link Field and Child Link Fields are properties of the subformcontrol. Right click on it and turn on the properties window. Data tab.

The value entered into the form are written to the form's Record Source (also on the Data tab of the Properties). This can be a query or table.

The subformcontrol has a Property called the Source Object. This is the subform object itself. It in turn has a Record Source. Data entered into the subform is stored there.