I have a foreign key ID field that has a list of IDs. I would like to run an ExecuteSQL query that will return another field in the record when a specific ID is in the foreign key field. The query below works if the search value is the first/top item in the list. The search fails if the matching value is not the first item in the list. Is there a way to get ExecuteSQL to match on any value in the foreign key field?
--- Current query, works when ? is first value in the list.
FROM "FieldManagement" a
WHERE a."PartDailyGoal_ID" = ?