Are you using good for expressions on your statements?
COUNT ALL will give a count of whatever workarea is selected
COUNT ALL FOR !EOF("Child") will tell you how many records have children.
>Ok..here it goes.. I have two tables with a temperary relation setup between the tables using the following statement
>
>SET RELATION TO no INTO Plw ADDITIVE
>
>no problems yet..
>
>everything works fine.. I click on the parent table and scroll thru the records it shows the related records in the child (target) database
>
>Now for the problem...
>
>No commands work on the relational (target) table. Count gives the full count of the database not the number of relational records.
>
>Locate does a locate on the whole table.. most of the commands seem to act as if there is no relation.
>
>Anybody have any relational counseling experiance?
--Todd Sherman
-Wake Up! Smell the Coffee!