relationship issue

[ICTkirsten]

Hello,

Im trying to connect my TimeslotID in times table to timeslotID in appointments table.. but it wont work

data type of timeslotID in times table : primary key and autonumber

and in Apt table it is :number

 

[bob fitz]

but it wont work

Can you be more specific.

 

[ICTkirsten]

Hello

this msg appears when i try to make a relationship

 

[bob fitz]

The error mesage is telling you are trying to create a one to many relationship but can not because you have values in timeslotID of appointments table (the many side of the relationship) that do not appear in the times table (the one side of the relationship)