How many records do you have in PL?
If you don't have many records you could create an unstored calculation field in PL that has the calculation: Count ( CH:CHID ). Now do a search on PL for records where the new calculation field has a value of 0 (if you deselected Do not evaluate if all referenced fields are empty) or blank ("=" in Find mode, if you left Do not evaluate if all referenced fields are empty selected). Performing a find on an unstored calculation can be quite slow if you have a lot of records, however.
If you have a lot of records you might be better off using ExecuteSQL, depending on your version of FileMaker
1 of 1 people found this helpful
I believe you can pull all records that match CHID to CHID and then display the Omitted records.
assuming this relationship:
PL::CHID = CH::CHID
go to a layout based on PL
If not already present, put the CH::CHID field on this layout.
Enter find mode
Enter an asterisk into the CH::CHID field
Select the omit option
Perform the find.
This can also be a scripted find and then the CH::CHID field need not be present on the PL based layout.
you can try:
1) add a value list ("list1") that use values from fields PL::CHID;
2) create a unstored calculation field "listField" in PL = ValueListItems ( DatabaseNames ; "list1" )
3) create a relationship CH::CHID <> PL::listFields
4) add a portal in PL layout that shows related record from CH, and add CH::CHID
5) add a Buttom in PL Layout with script "Refresh Window[Flush cached join results]
Thank you all