Update many to many relationship via form (guids)

[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)?

 

[John Vinson]

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)?

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.