>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
If you use a parameterized view for the child records, then reccount() will return the number of records directly. Otherwise you will have to do a COUNT.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)