lookup copying data both ways
I have two tables, an Estimate and an Invoice database.
I have a relationship built between the two to enable the Invoice to copy the info from the Estimate when I type in a matching docket number on the Invoice.
This works fine but the problem is when I modify the Invoice it also modifies the Estimate which a look up is NOT supposed to do.
Where am I going wrong?
Thanks in advance