Linking Tables

[Playa]

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.

 

[Mike Painter]

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.

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