I have a database with thousands of tracking numbers in different applications. I want to be able to have a search function wherein if I enter a tracking number, it will search
all applications, not just on that application where a “Quick Search” is present.
Is this possible?
so u mean search multiple tables? or a single table?
Multiple tables.
Can you make a union on those tables? That may resolve the issue…
select ‘table1’ as tbl_name fild1 as name,fld2 as id from table1 union
select ‘table2’ as tbl_name somefield as name,nr as id from table 2 union
…