>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?
Bruce, depending on how you're moving your pointer you could use the following. I'm guessing that you're moving the pointer in a grid and have the count showing in a text box or label.
SELECT Count(*) FROM Child ;
WHERE Child.ForeignKey = Parent.PrimaryKey ;
INTO ARRAY laCount
You can use the laCount[1] like a variable by just using laCount.