I've just added two new tables to my existing 14-table database, and can't define the new relationships how I'd like.
The 2 new tables are tbContainerType and tbContainer.
I want them to link as:
tbContainerType 1-many tbContainer 1-many tbAccessionItem
I have a field ContainerType in both tbContainerType (primary key/auto number) and tbContainer (text) and a field ContainerID in both tbContainer (text)and tbaccessionItem (text).
I want referential integrity between them with update and delete cascades but I haven't been able to set this - the fields are greyed out.
The ContainerID field has always existed in tbAccessionItem and I've gone through it to check that every record is accurate. I've created all the records for tbContainerType (there are only about 10) and for tbContainer (1359 records and growing) so that the itegrity etc is there (I hope - I keep checking), but it still won't work.
Any suggestions on what I've missed?
Cheers, Robyn
The 2 new tables are tbContainerType and tbContainer.
I want them to link as:
tbContainerType 1-many tbContainer 1-many tbAccessionItem
I have a field ContainerType in both tbContainerType (primary key/auto number) and tbContainer (text) and a field ContainerID in both tbContainer (text)and tbaccessionItem (text).
I want referential integrity between them with update and delete cascades but I haven't been able to set this - the fields are greyed out.
The ContainerID field has always existed in tbAccessionItem and I've gone through it to check that every record is accurate. I've created all the records for tbContainerType (there are only about 10) and for tbContainer (1359 records and growing) so that the itegrity etc is there (I hope - I keep checking), but it still won't work.
Any suggestions on what I've missed?
Cheers, Robyn