ADVANCED SEARCH MULTIPLE TABLES

I assume that the information from all of the tables shows on the list page at one time. I would link the tables to establish a master child relationship, then at the query page I would use "Add table" to bring the child tables into the query. Clck on the fields in the child table that you want to show up on the page with the master (List Page). When you go to the List page you will see the fields from the master table plus the ones that you called in from the child tables. Then use advanced search to search whichever fields you want to search on
Arthur

I assume that the information from all of the tables shows on the list page at one time. I would link the tables to establish a master child relationship, then at the query page I would use "Add table" to bring the child tables into the query. Clck on the fields in the child table that you want to show up on the page with the master (List Page). When you go to the List page you will see the fields from the master table plus the ones that you called in from the child tables. Then use advanced search to search whichever fields you want to search on

Thank you Arthur for your reply .... in truth I have already done how you have written....

but I'd like to know how you solve this problem ...

I have linked the master table to child table (they are 2) with LEFT OUTER JOIN, the relationship is one-to-many so in the list page of master table, the LEFT OUTER JOIN will repeat records in there are more then one record in the joined table .....

and this is not the best solution !

Possible that isn't there any solution for this?

alessandra