I have the following tables:
Reports (table created for running various reports related to contacts)
Signups (signup records for school dates attended)
I have a Contact portal on the Report layout showing all contacts. On the Reporting layout, I also have two global fields for the start and end date--both are calendar dropdown and are setup as date fields.
I would like to filter the portal by students who attended a school date in that range. I have no SQL experience and was wondering if that was the only way. I know how to do basic relationships where you can use a global field and < or >, but only for one record, not multiple.