>>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.
It's "my" world. You're just living in it.