How can I detect the number of child records in a relationship 2

[GuitarSlayer]

I have two tables which have a relationship set. When the record pointer is moved in the Parent I need to know how many records there are in the Child. Any Ideas on how I can achieve this?

 

[rgbean]

The way I do it, is to SEEK on the parent key value and then do a COUNT REST WHILE parentkeyvalue = childkey.

Rick

 

[thuvan1957]

(Assume the relation expr. is Code)
In the Parent alias:
SET SKIP TO (chindren alias)
GO RECN()
m.Code= Code
COUNT TO NumberOfRec WHILE chindren.Code = m.Code
(that ~ move to next record in Parent alias)