>>>I need to display on the grid in the form the following: invt.styleno, styles.desc, invt.size, invt.color, invoitem.price, invoitem.qty fields. The problem is, how should I setup the grid to display this in the easiest way? I've tried using param. view in a optimistic buffer mode but when I add new items, the lookup fields (fields based on INVT and STYLES table) aren't displayed, only fields based on INVOITEM.
>>
>>Did you do an APPEND BLANK in all 3 tables?
>Actually, I don't need to insert new rec in all 3 tables since INVT and STYLES tables are used for lookup only. I do insert a new rec in the INVOITEM table since this table is the only one I need to add/edit/delete recs in.
>>
>>>When I try to refresh the grid, I get an error that I need to update the view but I want the option to TABLEREVERT later so I don't want to update the view until the whole invoice is ready to be updated. Any suggestions on how I should set this grid up?
>>
>>Personnaly, I don't do updates directly in the grid. I put command buttons ("New", "Modify", "Delete") and present a form for data entry.
>I'm not using the grid directly to update the grid either. The way I have it setup, I have a pageframe with 2 pages, first page is where the grid resides and the second page is textboxes to gather new line-item data when the user clicks a "New" command button that is also on the form. After gathering the info. on the 2nd page, I have a "Save" button where I'm inserting a new rec into the INVOITEM table. But after I add a new rec and go back to the first page, the grid shows only data from the INVOITEM fields and data from other 2 tables are blank. Only way to show does fields is if I update the view which I don't want to do until the whole invoice is finished.
>
>Thanks
>John.

I presume you are getting key values from your lookup tables and INSERTing them in your grid table before TABLEUPDATE. Go ahead and insert the display fields from your lookup table while you are at it. It may seem like some sort of duplication, but at least you can see them immediately without REQUERY(). Those fields in your view should not be updateable.