multiple one to many relationships between the same tables

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

I have two tables with the following details

tblCodes
Code - primary key
Description

tblAttendance
AttendanceID
Date
ServiceCode
TreatmentCode

Im trying to link the tables twice, so that tblCodes.Code is linked in a one
to many relationship with both ServiceCode and TreatmentCode. Linking the
tables individually works fine, but as soon as i try to link both Service
and Treatment at the same time i get errors.

Any help would be appreciated, thanks

Tom
 
You need to link two copies of tblCodes to tblAttendance. One links to each
of the Code fields.
 
Back
Top