I have posted a similar query in the general forum but this does appear to be a bug:
I have 2 tables, clients and sites with records in sites related to records in clients through clientsid.
In the clients record form I can search for and locate all clients related to site A by entering ‘site A’ as the search criteria in the related field ‘clientid’ in the sites table.
If I want to then extend the found set to include all clients related to site B as well I would have thought I should enter Find, put ‘site B’ in the related ‘clientid’ field and select Extend Search. This does not work - it simply returns all records in the client table, even those that are not related to either site A or site B.
However, if the first search is within the client table, say for client name = Peters and then the second (extend) search is for any clients related to site A this works correctly. i.e. the problem only seems to arise if both the initial and the extend searches are for data in related tables rather than the one currently being viewed.
Trying any of the above using methods rather than manually produces the same results.
I have tried this in both 1.2 and 2b6 with the same results.