I have a client that has an older db that uses repeating fields. For phase 1 of the project, I am not quite ready to remove them. He sells to retail and wholesale clients and I'd like to relate his inventory file which contains a retail and wholesale price to his invoicing system. But I can't figure out how to displace the right price based on where his customer is a retail or wholesale customer. Any thoughts on approach. Remember, his invoices are now using repeating fields and not portals with a separate invoice line item db.

You could lookup both and select the correct one locally.

Or Lookup as an auto-enter result using Lookup ( ), may be with

Lookup(Wholesale::price;Lookup(Retail::price))

Is the Lookup function FM7 because I don't see it in V5.

Can you elaborate?

Not sure where the difficulty lies... If there were only one price for all clients - would you know how to look it up? Ok, then lookup the retail price as if it's the only price. In another field, do the same for the wholesale price. A third field is a calculation field that chooses between the two looked-up prices, according to the client status.

Unfortunately, Ugo's suggestion is FMP7 only.

Thanks. Got it.