>I have two tables related together and want to be able to count the number of associated child records whenever I move the pointer in the parent table.
>
>How do I do this?
>
>Thanks!
Use either Select SQL (if tables unbuffered) or count, e.g.
select child
lnRecno=recno()
count for ChildID = m.lnParentID to lnChildren
go to lnRecno
select Parent
If it's not broken, fix it until it is.
My Blog