multiple one to many relationships between the same tables

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
 
D

Duane Hookom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One To Many Relationships - Series of Related Tables 9
Relationships 7
relationships/ tables 2
Understanding Relationship Logic of Multiple Tables 2
Many-to-Many Relationships 4
Relationships between multiple tables 5
Relationships, forms and command buttons 8
Multiple Many-to-Many relationships 8

Top