I have different GROUP Name with different MEMBERS.

Now I'm trying to make a database reporting on each GROUP, I want each group to input their reports and identify who among their MEMBERS attended their meeting.

What I want to achieve is, when a user input a GROUP name, on the "look up" field under ATTENDEES only show those MEMBERS included in the GROUP name selected.

Right now, all MEMBERS in the look up field (regardless if what GROUP) are all showing, which I don't like because the list is too long.

For example:

Group Name: Group A

Attendees: (should show only members from GROUP A, then multi select)

Please help. Thanks.