AnsweredAssumed Answered

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

Question asked by juandent on Sep 15, 2016
Latest reply on Sep 15, 2016 by David Moyer



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