main and secondary forms

ajm

Registered User.
Local time
Today, 06:13
Joined
Oct 6, 2006
Messages
16
Hi
I have a main table in my database. For each record in this table there may exist 0, 1 or many records linked to it in a secondary table.
I have created a form for viewing the records in the main table, and now want to link to a second form that displays the records in the secondary table, if indeed any exist for the main record being displayed on form1.
Specifically . .
If I can detect whether secondary records exist for each record in the first, how can I pass a parameter (ie Table1id) to the secondary form so that we can view only the secondary records associated with the main record selected ?
thanks
ajm
 
It appears to me that you want a Main form and subform.

Have a look at sample that I posted HERE
 
Ace thanks

Thats ace.
many thanks !!!
 

Users who are viewing this thread

Back
Top Bottom