MS ACCESS 2000
Hi All,
Short question: Is it possible to link a subform to a subform when both of them are in the same tab control?
I try to make a database to store information about existing birds in a Ramsar area, aiming to donate it to a local non-govermental organisation.
There are 3 tables:
Table 1: "BirdsTbl", PK BirdID
Table 2: "ReportsTbl", PK ReportID, FK BirdID
Table 3: "MultimediaTbl", PK MediaID, FK ReportID
Tables are linked as discribed above.
In a form, I have a Tabcontrol with 4 pages.
Page1 and Page2 host the controls of "BirdsTbl" (The main table)
Page 3 hosts the controls of "ReportTbl" and is linked to the page 1 as a Subform (I have designed the subform on the basis of ReportsTbl, I droped it in page 3 and made the connections accordingly)..
Now, I'd like to place on page 4 a new subform which is made on the basis of table "MultimediaTbl" and to link it to subform on page 3.
I
have tried to use the same procedure as in page 3 subform, but without success. The master field ReportID was not present.
Is there a way to achieve this?
Thank you in advance
Dimitris
Hi All,
Short question: Is it possible to link a subform to a subform when both of them are in the same tab control?
I try to make a database to store information about existing birds in a Ramsar area, aiming to donate it to a local non-govermental organisation.
There are 3 tables:
Table 1: "BirdsTbl", PK BirdID
Table 2: "ReportsTbl", PK ReportID, FK BirdID
Table 3: "MultimediaTbl", PK MediaID, FK ReportID
Tables are linked as discribed above.
In a form, I have a Tabcontrol with 4 pages.
Page1 and Page2 host the controls of "BirdsTbl" (The main table)
Page 3 hosts the controls of "ReportTbl" and is linked to the page 1 as a Subform (I have designed the subform on the basis of ReportsTbl, I droped it in page 3 and made the connections accordingly)..
Now, I'd like to place on page 4 a new subform which is made on the basis of table "MultimediaTbl" and to link it to subform on page 3.
I
have tried to use the same procedure as in page 3 subform, but without success. The master field ReportID was not present.
Is there a way to achieve this?
Thank you in advance
Dimitris