I looked at several threads on this issue but am still unsure as to how to solve this. I have a cemetery database which is somewhat different from the other situations discussed.
The main form is a record of "Plots" which is based on a query. "Plots" and "Owners" have a many-to-many relationship. I want to include owner(s) information from the owner table (one or more) for each lot. If the "owner " does not already have a record in the "owner" table, I would like to add that information to the owner table (through the owner form) and then add that owner to the plot form.
A snapshot of the main form (the plot form) and the relationship is attached. As of now, the "owner" form has been included as a subform in the main form. But this requires filling out the same information multiple times which I want to avoid.
Thanks for any help.
The main form is a record of "Plots" which is based on a query. "Plots" and "Owners" have a many-to-many relationship. I want to include owner(s) information from the owner table (one or more) for each lot. If the "owner " does not already have a record in the "owner" table, I would like to add that information to the owner table (through the owner form) and then add that owner to the plot form.
A snapshot of the main form (the plot form) and the relationship is attached. As of now, the "owner" form has been included as a subform in the main form. But this requires filling out the same information multiple times which I want to avoid.
Thanks for any help.
