Announcement

Collapse
No announcement yet.

How can I achieve this with a dynamic search?

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

  • How can I achieve this with a dynamic search?

    Hello

    I have 4 tables in SQL Server. 3 of them are catalogs (Country, Network and Platform) the fourth table contains records of documents. There are multiple fields in that table, but those that serve to differentiate each record are the following:
    • Document
    • Access
    • Country
    • Net
    • Platform

    Each document can contain multiple accesses, but never one equal to the other within the same document.

    All countries can have the same Network and Platform.

    Ex.
    Document Access Country Network Platform
    12345 123 USA 10 15
    12345 124 USA 10 16
    12346 125 CAN 10 15
    12346 126 CAN 10 16
    12347 127 MEX 11 1
    12348 128 BRA 10 15
    12348 129 BRA 10 16


    How could I achieve a dynamic search that allows me to show in a grid only the accesses of a specific country, network and platform?

    Ex.

    if I search ...

    Country USA and CAN
    Network 10
    Platform 16

    the result must be ...
    Document Access Country Network Platform
    12345 124 USA 10 16
    12346 126 CAN 10 16
    As I use codes to identify the country, the network and the platform, I need the search fields to be shown as a select field so that the user can easily choose the country, network and platform he needs. These select fields must be filled with the values of the tables that I use as catalogs..


    Table Country fields

    Country
    Name

    Table Network

    CountryCode
    Network
    Name

    Table Platform

    CountryCode
    NetworkCode
    Platform
    Name


    I hope you can understand what I need to do and I would appreciate it if you could help me have an idea of ​​how to do it.

    Thank you,

    Aldo
Working...
X