Reflexive relation

[Fluffy]

Hey,

I have a table 'Hubs' with key 'Hubid'... Since a hub can be connected to another hub in a network, I have a reflexive relationship...

How do I do this in Access?

Any help would be appreciated!

 

[Mile-O]

Add a second instance of the Hub table in the relationships window and relate the ID field.

 

[Fluffy]

Okay, thanks...

But, since one hub can be connected to more than one hub, I have an n to n relation...

So, I have to add an extra instance in the relationships window and also create a new table to get rid of the n to n relation, am I right?

 

[Fluffy]

And what about the second instance in relation to other tables...

Do I relate the table 'PC's to both or only one of the 2 instances? I guess only one, but am not sure...

 

[Mile-O]

Create a junction table and link realte the two instances of the Hub table:


tblHub
HubID
Other Info

tblHub_1
HubID
Other Info


tblHubToHub
HubID (FK from tblHub)
HubID (FK from tblHub_1)

 

[namliam]

Just wanted to add 1 small note to make sure...

there will only be 1 table tblHub! But 2 instances in your query/relationship window.

Regards

 

[Fluffy]

Thank you!

 

[Fluffy]

Both are used on the net (I tried both on google)

I don't know which one is correct though...