James,

I'm actually looking for advice on where I would put the replace for the price field in my example. If I just put it in the Valid or LostFocus, doesn't this violate the 3 tier model?

TIA

Rex

>Rex,
>
>>
>>No, I mean that values of the record in a grid are populated based on a combobox in that grid. Think of the price column in an invoice, you enter the item and the system populates a price column from that item.
>
>SQL Passthrough or a lookup view would be the way to go here. I would probaby use SQL Pasthrough if it were a client/server system.