Jump to content
Sign in to follow this  

Counting Related Records

Recommended Posts

I've got two tables, a Client table and a table that stores changes to the services that they subscribe to. What I am looking for is a field in the clients table that stores the number of records in the changes table that have a field set to 'N'.

I set up two new fields in the clients table. One is where I want to have the count, the other is a Global that contains the value 'N'. For the count, I'm using: Count ( Changes::posted_to_clients )I've also set up a new relationship between the two tables where the keys are Clients::client# equal to Changes::client# AND Clients::globalvalue equal to Changes::posted_to_clients.

When I set this up in one database as a test using 0 and 1 for the posted_to_clients field, it appears to work. Unfortunately this is a legacy system and the current values in the posted_to_clients field are 'Y' and 'N'. Is there a reason why this won't work because it appears to fail. I've tested with both 8.5 and with 9 and get the same results.

Share this post

Link to post
Share on other sites

Hi Steve

It would appear that one of the fields (I suspect the global) is a field with a result of number rather than text. That might explain why it works with 1 and 0 but not 'n'



Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.