Jump to content

Finding parent records with children


This topic is 6105 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a solution, running on FMS, with a relationship that looks like this...

table 1::emp_id = table 2::emp_id

table 1::global_thru_date = table 2::thru_date

I have a calculation field in table 1 that is defined as

table 1::count = count ( table 2::emp_id )

It tells me the number of records in the child table for each parent record. As expected the count displays the correct number of records when I change the global_thru_date field. If I perform a find using the field count where count > 0 filemaker will find parent records that do not have any child records. But not all childless parent records. This works as expected when not running on the server. Any ideas anyone.

Edited by Guest
Link to comment
Share on other sites

Your count calc uses the relationship that limits the children to those that have the same thru date as global_thru_date.

You may want two relationships from Table 1 to Table2. One that includes the filter g_thru_date and one that sees all the children.

count.zip

Link to comment
Share on other sites

That is exactly what I am after. I want to find the parent records when the thru dates match the children. But that is not what I get. It also finds parent records that do not have matching thru dates. Again, this behavior only occurs when running on the server. Globally defined fields are local to the client, right? That is, each user connected to the server can have a different value in a globally defined field at the same time, correct?

Link to comment
Share on other sites

In this case it is the last day of the month and only the last day in a month. The child records hold statistical information that occured through the end of the month.

Link to comment
Share on other sites

This topic is 6105 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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