>Thanks Barbara for reconfirming my observation. Then, isn't using views impractical for displaying child table that have lookup column in this kind of situation? This seems to be a serious drawback to me. Either force an update in the middle of data entry OR having to loose the ability to view lookup info in the grid is a no win situation IMHO. I know you use views a lot for child table viewing so how do you handle it?
>
>TIA, again.
>John.
John, are your using the original table for data entry? And then trying to see that information on your view/grid? If this is the case, your will have to save the data before you re-query the view to see the new data in the grid.
If you are using the view for data entry, then you should be able to see it whether on the data entry form or in the grid without a requery. Just refresh the grid from the view.
As you can see, I'm somewhat confused about exactly what you're doing.
Barbara