Search on inverse link fields?

[Greg Maletic]

I have a one-to-many link set up between two forms. Let’s call the forms A and B.

In B — which has an inverse link back to A — I would like to have a search set up that can show me all the records in B that have _no_ link established, i.e., the inverse link field is blank.

But when I try to do a search on B, the inverse link field does not show up. Is this a limitation? If so, is there another way to accomplish what I want?

Thanks.

[Brendan]

Hi Greg,

There’s no function to search a parent form for any values contained in a related form.

However, you can workaround this by using either a Script field or a Calculation field.

On your form B, add a Calculation field. Edit the formula and choose a field from the list of fields that show up that are contained within the parent form A. Any field will do. Then you can add a Saved Search that checks to see if the value of the calculation field is empty or not.

Hope that helps.

Thanks,

Brendan

[Greg Maletic]

This worked! Thank you.

[Author]

Posts