Getting a Value, not a related field

[chase]

I just need to get the value (price) of a field for an invoice. The pricelist obviously changes, but i want each invoice to keep the value from when it was created, not update when the pricelist is updated.

Please help.

John (Chase)

Edited January 6, 2010 by Guest

[bcooney]

You need to get the price of an item in your invoice items record?

In the invoice item table, set the Price to lookup (its an entry option for the field) from the pricelist when ItemID = ItemID.

A lookup captures the value in the other related table, and copies it.

Edited January 7, 2010 by Guest