Creating relationships between records

[GLW]

I am trying to find a way to create a relationship between
2 (or more) records and have the related record ID show on
both records. For example if I am working on record A and
I select record B in the 'related record' field I want to
see record A populated in the 'related record' field when
I go to record B. What I have so far is a 'related
records' table with 2 columns Primary and Related and a
subform based on this table with Primary as the child
field to parent RecordID on the main form. Should I put
an append query on the afterupdate event to add the other
side of the relationship? Or is there a way to display the
relationship on both records without creating an
additional row in the related records table?

 

[Allen Browne]

You cannot create a relationship that auto-generates a record in the related
table.

Yes, use the AfterInsert event of the form where the primary table's records
are entered, to execute an Append query statement on the related table.