Creating relationships between records

  • Thread starter Thread starter GLW
  • Start date Start date
G

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?
 
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.
 
Back
Top