Solved
Formula Query with custom key
I have a parent table with a custom key, and I have several formula fields with formula queries that pull data into the parent. The ones that are summing into numeric fields work, but I also have on...
I would highly advise against using formula queries if you have a direct parent/child relationship between the records. A summary field with a filter for any checked child record would suffice.
That being said, if field ID 43 is a checkbox so the use of "High" isn't likely what you want. Try it with "yes" instead.
Let me know if that works - Sharon
