One way to accomplish this would be to define a calculation field in your parent table as IsValid (relatedTable::foreignkeyfield)
Find on that calc field for the number 1
Omit Date Field "="
Constrain Found Set
From the context of a layout based on the first table:
Enter find mode
put an asterisk in the field from the related table
perform the find
you can script this find or do it manually.
Yup. I was overcomplicating things. I tend to do that.
Apparently, It worked just fine until I started adding more fields which must be empty for the search to be successfull with its purpose. I'm attaching a print screen of the relations between the tables and a print screen of the search script. When I add the highlighted search restrictions that you can see on the search script, It stops finding the records correctly.
Please let me know If you find anything wrong. When I play the script, no records are found which is wrong, as there are records matching the search restrictions not being found.
I would really apreciate any help or support!!
From what I can see, you are now using some hybrid of the solution I suggested and the one philmodjunk suggested. You should use one or the other.
If you are using mine, then you need to OMIT fields with "="
The problem occurs when the find is restricted to look in another field from a 3th related table or at least, when relating the search to these specific tables (Note that the last two restrictions are set to look at the tables "clientes_FASE JUDICIAL" and "clientes_FASE COBRO" (Both also realated to the parent table). If I perform the find in the next screen print, a wrong "no records found" result.
I have tried to perform this find relating the last two tables. The result should be 3 records found. However, no records found is also the result of the search.
This make me believe that perhaps some configuration on the tables or even the relation might be wrong (Note that, "clientes_FASE EXTRAJUDICIAL" and "clientes_FASE COBRO" are related by field "_numero_serie" but the table "clientes_FASE JUDICIAL" is related by the field "Nº_demanda".
Thank you for your comments Philip!.