I was hoping to get some help with this design. It seems so simple but can't get my head wrapped around.
design scope:
User 1 enters drawing(one) and location's(many)
User 2 finds the record and add the additional Pass and various other information.
Reports generated, boss is happy.....
I need to write a new record to the tblTest after a drawing and location is entered. there may be multiple locations and more may be added at a later date.
I though writing from the form without the relationship but do no want to duplicate drawing and location records.
I attached a simple version of what I am trying to accomplish.
Thanks again
design scope:
User 1 enters drawing(one) and location's(many)
User 2 finds the record and add the additional Pass and various other information.
Reports generated, boss is happy.....
I need to write a new record to the tblTest after a drawing and location is entered. there may be multiple locations and more may be added at a later date.
I though writing from the form without the relationship but do no want to duplicate drawing and location records.
I attached a simple version of what I am trying to accomplish.
Thanks again