TWO TABLES AS SUBFORMS IN ACCESS...HOW DO I LINK THEM?
Posted on 2012-03-22
I have a Microsft Access Solution I am repairing.
I have three tables.
TBL1 is parent to TBL2, and TBL2 is parent to TBL3.
I also have FORM1, which represents TABLE 1 and has the necessary fields.
inside FORM1 is SUBREPORT1 which displays TABLE 2, in a table format for data entry. Table 2 is linked to Table one via FORM1's Link Master/Child Fields.
I want to integrate Table three. I want to make a subreport2 which will hold Table three, and have a relationship set (master/child) between Table 2 and Table 3.
Can I do this? If so, how?
in short, Form 1 represents Table 1. Subreport 1 represents Table 2 and is Child/Master Locked to Table 1. I want Subreport 2 added representing Table 3 and lock it Child/Master to Subreport 1. Both Subreports are on the same Form.