4 Replies Latest reply on Sep 15, 2016 1:23 PM by David Moyer

    How can I filter a table to show only records that have an existing relationship with another table?




      I have a table Concepts which has a relationship with a table StatementLines. They are connected like so:



          Concepts.id_concept = StatementLines.idf_concept

          Concepts.g_start_date <= StatementLines.line_date

          Concepts.g_end_date >= StatementLines.line_date



      where the g_start_date and g_end_date are global fields on Concepts.


      I want to display Only those records from Concepts that have an associated corresponding record in StatementLines according to the relationship specified above.


      Can you help?


      It seems that this kind of problem must have come up many times to other programmers...




      Juan Dent