hunterfan48
Registered User.
- Local time
- Today, 06:30
- Joined
- Aug 17, 2008
- Messages
- 436
I've got this table with two particular fields in there (Year) and (Manufacturer).
I've just been having these two fields use a value list to select from for entering the correct value for (Year) and (Manufacturer).
However, I would like to set two new tables up for these two fields that way I have an unlimited amount of records I can enter.
So, I set each table up as follows.
(PK) ID--Autonumber
Manufacturer--Text
(PK) ID--Autonumber
Year--Text
I tried to tie these into my original (Inventory) table that contains these two fields.
How can I relate them so I can
a) enforce referential integrity
and
b) cascade update related fields.
??
It says the relationship type is Indeterminate.
When I try to create, it says no unique index found for the referenced field of the primary table.
Thanks
I've just been having these two fields use a value list to select from for entering the correct value for (Year) and (Manufacturer).
However, I would like to set two new tables up for these two fields that way I have an unlimited amount of records I can enter.
So, I set each table up as follows.
(PK) ID--Autonumber
Manufacturer--Text
(PK) ID--Autonumber
Year--Text
I tried to tie these into my original (Inventory) table that contains these two fields.
How can I relate them so I can
a) enforce referential integrity
and
b) cascade update related fields.
??
It says the relationship type is Indeterminate.
When I try to create, it says no unique index found for the referenced field of the primary table.
Thanks