Does a field of type collection has records in the main table?
I have a table "A" which has a field "A1" that is of type collecttion applied to the table "A" itself. I need to know if the records on the collection of "A1" are also records from the main table "A". Anyone have an idea?Motivation: When I use a search field on the table "A" on a form, but the records was created as a collection are not returned in the filter. I can not see the records that are part of the collection in this field.