Relationship problem

  • Thread starter Thread starter TBird
  • Start date Start date
T

TBird

In my database, I have two tables (MOD and GFE) that I need to link t
the same field in a third table (MTC). Both are many to on
relationships. I am trying to set up this relationship in th
"Relationships" window but it only seems to be allowing me to link one
I say one because when I go to MTC table and click the "+" at the fa
left, I can only see one of the tables linked. Am I missing somethin
here
 
I assume you mean that it is MTC - MOD (1-m) and MTC - GFE (1-m)

The sub-datasheet can only show you one foreign table at a time.

You really should create a form to display the information. You can create
a form based on MTC and have two subforms, each bound to the MOD and GFE
tables.
 
Back
Top