AnsweredAssumed Answered

Showing only matched records from relationship

Question asked by JustinLevens on Jun 28, 2011
Latest reply on Jun 29, 2011 by JustinLevens

Title

Showing only matched records from relationship

Post

I have a many-to-many relationship.  One table is holding around 5 records per subject and there is another table holding appointments.  The appointment tables is coming from an enterprise appointment scheduling product.  What I'm doing is matching up when an appointment/visit might match up to an assesment based on a date window.  I have the relationship working perfectly however because there are many assessments per subject there are a bunch of empty records where I'm pulling in the appointment information.  I would only like to see the records where there is a match between two tables via the relationship and omit the other records.  Any suggestions or settings to get this to display right?  What I'm going to end up doing is quering this table for assessment date and creating a report.

Outcomes