I am creating a meeting attendance application with a members 'table' and a meetings 'table'. I have my meetings forum using a lookup field for the members 'name' field. It's working great and it makes it very easy to record attendance.

However, I am trying to view an individual member's attendance. I know that in the meetings view I can filter by particular members in the 'Attended' lookup field, but I want to be able to print off a sheet that lists all the members and their recent attendance.

What this comes down to is not knowing how to alter the members 'view' to lookup where the member was recorded in a lookup field. In MySQL, the query would go something like:

SELECT `date_field` FROM `meetings` WHERE 'Member Name Here' IN(`attendance`);

I'm sure I'm not the first one to need something like this, but unfortunately I just can't get my search keywords to find the answer. I appreciate your replies.