Finding if a txt value exists among related records

[alithis]

I basically have a yes/no field in a certain table containing child records. I have a master record that needs to know if there is a yes among any of its related records.

I need a calculation in the master table to tell me if a yes exists among the values of its child records.

|   child table     |         |   master table  |

masterid  isSomething    <--   id  hasSomething

1         yes                  1   :

1         no

1         no

1         no

Thanks for any help.

[Ocean West]

Welcome to the forums!

So in Child table create a field:

boolean: isSomething = "yes"

Then in MasterTable

Sum ( child::boolean) = true

This will give you a total of all the yes and if it's ≥ 1

You wouldn't need the added field if the isSomething field were number and then you displayed the format to be Yes/No, you could use a script to toggle the 0/1.

Edited October 24, 2009 by Guest