Jump to content
Sign in to follow this  
oakbridge

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'

HTH

Phil

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.