Hi,

It has been a couple of years since I have used Access and seemed to have forgotten quite a lot!!

I am trying to set up quite a simple database recording late deliveries from suppliers. I have 3 tables, 1 with the suppliers in, 1 with the part numbers in and 1 for the actual failure (with the part no and supplier as FK)

However, for some reason I cannot get my relationships to set up as 1-many and access says they are intederminate.

Any help appreciated. I have attached a copy of my database as it stands at the moment


Thanks
Chris

In your table tblCatNo, your primary key has Duplicates (Yes) in it instead of Duplicates (No). Change it and the relationships will move from Indeterminate to One-to-Many.