Solved: How to exclude a value from the list in ref field? - Page 2

Mark_Holanda · 04-07-2020 07:26 AM

hi guys,

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

regards,
Mark

Mark_Holanda

so i just the change the greater than to less than symbol…

heres the final code:

SELECT(Events[EVID], 
   OR( 
  NOT(
      IN([EVID],
         SELECT(Events[EVID], [DATE] <= TODAY()             	
         )
      )
 	), [EVID] = [_THISROW].[Event ID]
)	
)

thanks again mate!

View solution in original post