0

Filtering with many arguments in a related table

Hi, I wonder if you can give some ideas on how to find a solution for this: I have a table of Spares related to a table of Instruments, I have a Report table that stores many instruments in the table Report_instruments, what I want is to add a new table related to Report that stores Report_spares, so I need to use the actual instruments in Report_instruments (that are many) to filter the Spares in a ComboBox so I can see only the related spares to the instruments I have selected previously.

 

Tables

Spares, this one is related to instruments

Instruments, this one is related to spares and also to Report_instruments

Report, this one is related to Report_instruments

Report_instruments, This one is related to Report_instruments and Instruments

Report_spares, related to Report and Spares

1 reply

null
    • John_Halls
    • 2 yrs ago
    • Reported - view

    Hi Leodardo

     

    Can you tell me what the tables Report, Report_instruments and Report_spares do? Are they used as dashboards (typically having just a single record)?

     

    Thanks John

Content aside

  • 2 yrs agoLast active
  • 1Replies
  • 197Views