Hi All,
I have a search form based on a query "completed_addressqry" which has 2 tables "Completed_Addressed" and "Payment" the search works fine.
My issue is that some time ago I began to capture the full address not just the suburb, so I updated the query "completedqry" which was based on 2 tables "Completed" and "Payment" therefore I only get results from the new query, but I need to get search results from both queries, currently I am running 2 search forms, which is cumbersome and confusing.
My aim is to be able to use 1 search form, I have tried a query using the 3 tables ("Completed_Addressed", "Completed" and "Payment") this gives duplicate results.
Is it possible run a query and if there are no results found, then run a second query.
i.e. If I search with "completed_addressqry" if not results found then run "completedqry" so that I can get results from the 3 tables.
Thanks
DavRob
I have a search form based on a query "completed_addressqry" which has 2 tables "Completed_Addressed" and "Payment" the search works fine.
My issue is that some time ago I began to capture the full address not just the suburb, so I updated the query "completedqry" which was based on 2 tables "Completed" and "Payment" therefore I only get results from the new query, but I need to get search results from both queries, currently I am running 2 search forms, which is cumbersome and confusing.
My aim is to be able to use 1 search form, I have tried a query using the 3 tables ("Completed_Addressed", "Completed" and "Payment") this gives duplicate results.
Is it possible run a query and if there are no results found, then run a second query.
i.e. If I search with "completed_addressqry" if not results found then run "completedqry" so that I can get results from the 3 tables.
Thanks
DavRob