>Hi,
>I have a form which is to maintain the Invoice records in one to many relation, invoice header table and the invoice detail.
>When I browse the Invoice header table, I want to know how many child records refer one invoice no.
>Is there any system variable or function to get the no. of child records ?
>
>Please advise.
>
>Derek Yim
It depends on what exactly you're using. If you're using tables directly than perhaps you can do
lnInvoiceID = Invoice.InvoiceID
select InvoiceDetails
count to lnInvDetails for InvoiceID = m.lnInvoiceID
Alternatively you can use select-SQL statement if you didn't make any changes to the tables yet.
If it's not broken, fix it until it is.
My Blog