Hello David.
If you want to keep the relation you can use eof('childtable'). After each record change in the parent table eof('childtable') indicates wheather there are corrsponding child records or not.
eof('childtable') = .f. && no child records
All the best.
>Hi,
>
>I have an invoice form with a grid showing the items for that invoice. I would like to do a check before saving the invoice to make sure at least one invoice item exists. I use set relation to link the invoice and invoiceitem table.
>
>My question is how do i find out the number of rows in a grid? There seems to be no grid.rowcount property. The grid is databounded but only a subset of the records in the invoiceitem table is shown (for that invoice).
>
>Thanks,
>David
A moment of silence is our cosmic reset button.