M
McGeeky
Hi. The new database project I am working on has stepped up a level in
complexity; some of the forms do not map 1 to 1 with a table so the
create/delete/update methodology of Access does not apply (well, at least
that's what I think!).
We need to create relationships between two tables - we are doing this
through the use of an intermediate linking table to create the many to many
joins. The user's experience should be as follows; they click on a check box
on the form and a record should be inserted in the linking table - when they
uncheck the check box the record should be removed.
Is there best practice on how to manage this in Access? E.g. do we have to
use custom SQL insert statements, if so, then should we use a transaction to
do it in, should we create a new connection to do it in, how can we
associate that insert with changes to the table that the form is bound to?
Any best practice/guidance on this would be gratefully received!
Regards,
McGeeky
complexity; some of the forms do not map 1 to 1 with a table so the
create/delete/update methodology of Access does not apply (well, at least
that's what I think!).
We need to create relationships between two tables - we are doing this
through the use of an intermediate linking table to create the many to many
joins. The user's experience should be as follows; they click on a check box
on the form and a record should be inserted in the linking table - when they
uncheck the check box the record should be removed.
Is there best practice on how to manage this in Access? E.g. do we have to
use custom SQL insert statements, if so, then should we use a transaction to
do it in, should we create a new connection to do it in, how can we
associate that insert with changes to the table that the form is bound to?
Any best practice/guidance on this would be gratefully received!
Regards,
McGeeky