Linking Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you link a field in one table to four fields in another table. For
example I have a table...

Table: BODY PARTS
fields: BodyID, Body Part

The Other Table is...

Table: MEDICAL FORM
fields: ...., ....., ....., BodyID1, BodyID2, BodyID3, BodyID4, .....,
......, .....

So can I use the BodyID from my BODY PARTS table for all four BodyIDx in the
MEDICAL FORM table.
 
Playa said:
Can you link a field in one table to four fields in another table.
For example I have a table...

Table: BODY PARTS
fields: BodyID, Body Part

The Other Table is...

Table: MEDICAL FORM
fields: ...., ....., ....., BodyID1, BodyID2, BodyID3, BodyID4, .....,
....., .....

So can I use the BodyID from my BODY PARTS table for all four BodyIDx
in the MEDICAL FORM table.
Click to expand...

Yes but it will cause problems. You should normalize your tables so there is
only one BodyID part per record.
 
Back
Top