Function to determine if a record has a child record

[James Gill]

I'm trying to find out if there is a way to determine if a parent record has any child records via a calculation. I know I can do this by creating a script and setting a variable of the parent record and then doing a search on the child table, but to me that just seems like a convoluted way to go about this.

[lawaid]

... but to me that just seems like a convoluted way to go about this.

I would agree. You can have a searchable numeric field, instead.

In your Parent table, create a calculation resulting as a Number. Modify the following calc to fit your relationship and field ...

Count ( childrelationship::IDfield )

It's critical that the field being "counted" always have a value. Most developers use the ID field.

Hope this helps!

[comment]

Or just:

not IsEmpty ( Child::Matchfield )