Cross referencing records

[bellemmar]

I have a Contacts database. I want to cross reference associates. But I don't want to have to enter associates in both records. For instance:

If parent record is John Doe and in the associates subform I add Mary Smith, how do I make the reverse show so that Mary Smith's parent record would automatically show John Doe in the associates subform without me having to physically enter it.

Thanks!

 

[John Big Booty]

I suspect you will need to use a junction table. See Many-To-Many Relationships in the link.

 

[bellemmar]

I am very hung up on this. I think because I only have one Contacts table.
Basically I have one table of "bad guys" and I want to be able to link people who are associated. So if I'm in Al Capone's parent record, how can I link him to Bugsy Segal and have that same relationship reflect in Bugsy Segal's parent record without having to actually put it in both?