Link 2 subforms (1 to many relation) within one navigation form

serei

New member
Local time
Today, 10:22
Joined
Sep 2, 2013
Messages
2
Let's say :
1 navigation form called Nav_Main
2 subforms : 1 called master_form ( PK = id_master) (table : master_table)
1 called details_form (with id_master in it) (tables : details_table)
the relationship is still established
I want to switch from master_form to details_form and retrieve only records corresponding to the last id_master where I was in master_form

(do I absolutely need to recreate a parameter query of details_table ?)
What is (are) the simple way(s) to do it ?

Many thanks by advance (from FRANCE)
 
Is your nav_main form bound to a table?
If no, you might not need it. You can have a parent form bound to master_table and a subform bound to details_table. When you add the subform, follow the Access Wizard prompts to connect the forms using id_master.
 
thank you for answering . Of course the navigation form is not bound to a table
a nav_main form acts just as an empty object filled with the 2 subforms (master and details) , ( my purpous is two have 1 navigation form that integrates all the subforms concerned with a topic, for ex. Sales, or Employees,...) and not a detailed form opened as a popup window .
 
Apologies if I have misunderstood you, but it still appears that you don't need the nav_main form.
If you are making something like a Customer Relationship Management application (Business to Business) then you can do this with a parent form bound to master_table and displaying fields like id_master, CEOname, and HeadOfficeAddress.
On that form you can add as many subforms as you need, which will all be filtered by the current id_master in the parent form.
 

Users who are viewing this thread

Back
Top Bottom