Update many to many relationship via form (guids)

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

In an access db exported from a sql server db using guids,
what is the best/easiest way to establish a relationship
through the use of a form between data in two tables in a
many to many relationship (using a join table)?
 
In an access db exported from a sql server db using guids,
what is the best/easiest way to establish a relationship
through the use of a form between data in two tables in a
many to many relationship (using a join table)?
Click to expand...

Have two GUID fields in the join table as a joint two-field Primary
Key (each is a foreign key to the "one" side tables) - I'd guess
that's what you have.

Then base a Form on one of the "one" side tables, and a Subform on the
join table; use the ID as the Master/Child Link Field. The GUID need
not (and should not) be displayed on screen but it'll still work as a
link.

It's convenient to have a Combo Box on the subform to select the
desired value from the other "one" side - again, the GUID should be
the bound column of the combo but its width should be set to zero in
the Column Widths property so that its value is concealed.
 
Back
Top