AnsweredAssumed Answered

lookup copying data both ways

Question asked by KevinHewitt on Feb 10, 2011
Latest reply on Feb 12, 2011 by Sorbsbuster


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