Linking two unrelated subforms

[rlangford]

Hi all,

I am trying to link two unrelated sub forms to a main form so I am able to query data all at once and make a report that displays all this data at once. I do not know if this is possible. I will tell you to the best of my ability about what I have going on.

My main form is a shift report. The primary key is a auto number ID. The rest of the fields are date, name, shift, vehicle. etc.

The first sub form is area attendance. Field are as follows auto number ID (primary key), report ID(which comes from the main form, linked), the area, and the area attendance.

The second sub form is the event log. Fields are as follows auto number ID (primary key), report ID(which comes from the main form, linked), time in, and events.

My relationship now is simply primary key from the shift report (the autonumber) going to the first and second subforms report ID's.

Problem is I can not query two distinct subforms like this (I realized). Is there any work around to this? Or do you need more info. Thanks so much for any advice! -rlangford

 

[apr pillai]

I am not sure whether I understood you correctly. If you are trying to link the second sub-form to the first sub-form directly, rather than linking it to the main form, then check the attached image for clues.

The image comes from an article explaining some different tricks. The link to the article is given below:

Overlaying Sub-forms in Real-time