Announcement

Collapse
No announcement yet.

Universal / Global Search Function

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Universal / Global Search Function

    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?

  • #2
    so u mean search multiple tables? or a single table?

    Comment


    • #3
      Multiple tables.

      Comment


      • #4
        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
        ....

        Comment

        Working...
        X