Problem with a Lookup

[John_H]

I am new to FileMaker and databases in general. Hopefully this is an easy question.

I have a database with two tables, Customer Contact information and Invoice. I have a lookup setup to pull over Customer Info , Customer Number, Ship to Address from the Customer Address table to the Invoice. We want to be able to modify the Customer Ship to Address on the Invoice without it changing the info in the Customer Address table. Right now it is pulling the data over based on Customer Number but when we modify the Ship to address it is also changing the source address as well.

Thanks,

John

[bcooney]

What you need to do is create a ShipAddress in the Invoice table and set that to lookup (field entry option) the Ship Address in the Customer table using your existing relationship by CustID.

btw, any data that shouldn't be dynamic, such as a price in your invoice line items, should use the Lookup function.

Edited October 15, 2010 by Guest

[bruceR]

Or comparable auto-enter calc.

[projay]

Did you get an answer to your question? Jay.