I am still confused.
How would the Company form with the 4th table (InfoTable) bound to it shows the associated consultants and projects related to it?
for example:
there are 3 different consultants worked for company B for 4 different projects.
How can I build the Company form based on the InfoTable to show such information when I use....
Code:
DoCmd.OpenForm "frm_Company", , , "[CompanyID]='" & Me.[CompanyID] & "'"
I am thinking of using continues subforms. How would I link them?
What I want to show in the frm_Company are.....
Company Info
3 different consultants and their info
4 different projects and their info
Thank you very much