Hi every one, I'm new to this forum and I'm enjoying it Big Time.
I am kind of consused. I have two tables with a "many to many" relationship. I have linked the two using an associated (intermidate) entity (table). Now when I want to link a record in table A to a record in Table B, I have a macro that opens two forms, one that is bound to table B and on that is bound to a table that records a log for this relation, then I have and "Action Query" that appends the two keys in the accociative entity.
I was wondering if it is a good practice to use append queries. Does any one have experinec related to my case.