I have a problem that I've been trying to solve for a week now w/o solution. I'm trying to design a typical invoice form (parent/child w/child in grid) but with a little twist. The tables I use are:
1. Invoice.dbf - main invoice parent table
2. InvoItem.dbf - child table of invoice.dbf for line-items.
3. styles.dbf - table of style codes.
3. Invt.dbf - table of products that are based on styles.dbf.
Relations: INVOICE.INV_ID=INVOITEM.INV_ID, INVOITEM.REFNO=INVT.REFNO, INVT.STYLENO=STYLES.STYLENO
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. 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?
TIA
John.
It's "my" world. You're just living in it.