Listing qualified records in a field

[kenseye]

I have a medication table listing medications and a date that each medication is discontinued. I would like to list the medications in a field if it does not have a discontinued date. Otherwise stated, I would like to list only active meds while not including discontiued meds.

Using List (Medications:medication) gives me all meds. What function do I use to incorporate a qualifier prior to listing?

[comment]

There is no ListIf() function in Filemaker. You can either:

• define another calculation field in Medications and list the result; or

• set up another relationship to filter the medications; or

• use a custom recursive function.