im quite lost here. I have an attendance form to record attendees of a particular event. What i want to achieve is if the member is already added as attendee, i dont want his name to appear on the list dropdown.
Can you please help me? thank you in advance.
Here are the screenshots of my tables:
Attendance table - https://www.screencast.com/t/TeqbjlGs
Members table - https://www.screencast.com/t/baVfy9J5ALVz
Events table - https://www.screencast.com/t/KOr484or
Attendance form - https://www.screencast.com/t/rQnMctQWi