Sounds to me like the structure you would need is one contacts table.
Then a Join table to register the links you make between contacts.
This table needs an ID field set to Auto enter a "Serial Number"
Then a first contactIdFk number field.
Then a second contactIdFk number field.
In your relationship dialogue you make a second table occurrence of your contact table and link it's Id to the second ContactIdFk field in the Join table.
Link the Id of your original Contact table to the first ContactIdFk.
In fact I'm bad at explaining, I made you a quick example:
It's pretty basic but should give you a general idea.
This is exactly what I need. Seeing it like this helps me to understand how relationships work...nice one...
The way you have presented the dropdown to make the contact links is perfect...awesome.
The only other thing I need on the LayContact record for each contact is another table automatically showing who they have been linked too.
eg: In your example, Sherlock Holmes has a linked contact called John Watson. When I go to the John watson record in Laycontact, I also need to see that they are linked to Sherlock Holmes too - but on another table on this Laycontact page....does that make sense.
So basically, when I link contact 1 to contact 2, I can see this relationship on, both LayContact records. I presume this would be pulled from the Tbl_Contactsjoined table - and then presented on the LayContact layout....?? Can you help with that?
Thanks again very much for taking the time to do that for me...much appreciated
Do you mean 2 different portals?
Where you can see in the first portal who this person has been linked to.
And in the second portal who has been linked to this person? (Its difficult to explain) :)
If that's what you mean I'll make a quick adjustment to my example.
So here's what I came up with.
I hope that's what you meant.