>There must be something very basic about one-to-many grids that I am missing. I have a typical invoice form with a standard relationship set in the DE between INVHEAD (invoice header) and INVDET (invoice detail) on InvNo. When I page back and forth between invoices, everything works beautifully. However, whenever I add an invoice, here's what happens:
>
>I get the new detail line data in a modal form, total the invoice (using CALCULATE SUM), and refresh the grid so that the new line will show up. The grid goes blank whenever I refresh it. I have tried SEEKing the InvNo in INVHEAD to re-align things prior to refreshing --to no avail. All of the detail is there--it re-appears as soon as I page back to the target invoice once I have completed it. TABLEUPDATEing the detail has no effect. What am I missing?
>
>TIA.
If I understand your problem correctly, it seems that you're saving the detail records (child recs) before you're saving the parent record and thus your grid is left blank because the relationship is not valid until you save the main invoice rec. Try to save the main invoice record first before you save the detail child records.