MS Access help please

[Jon Boy]

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

_ = 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

 

[Jon Boy]

I have been thinking would I need a new table?

For example set up Antenna config this causes a lot of repeated data though I guess.

Its anoying cos many APs have many Antenna but you can't have many to many