Hello I have a little problem in access when setting relationships. I have always been told to enforce referential integrity or everything goes wrong
.
So anyway I have 2 tables and need two of one value to be in the table twice. if you get what I mean. To explain
Quote:
|
Originally Posted by Me
_ = PK
* = FK
Table Antenna
ID
Description
Table Access Point
Details etc etc ......
Antenna1 *
Antenna 2 *
|
As you can see each AP has 2 Antenna but I cannot set up two relationships without enforcing referential integrity.
Can someone please help on this subject please?
Thanks
Jon