I have a form in which users submit information on a Main Form, and include entries regarding completed service projects in a Sub Form. What I'm looking for is a way for each of the Service Project records to "fetch" their Main Form.
In the Main Form, the list of Service Project subform entries would be a List of the record IDs of those entries. So, in the Main Form the subform is called "Service", the record ID I want to match back to the Main Form is record_ID. When I try to run a fetch like
s = Main_Form [ record_ID in Service ]
it fails, because the criteria wants the Main_Form field first. s = Main_Form [ Service.contains(record_ID) ] also fails, because .contains() is reserved for strings, not longs.
Any help on what my fetch criteria needs to be?