Help setting up value list relationship

[Tim Hampton]

Hi There.

 

I have a table called: Users which contains the fields  User ID, Level, Gender

I have a table called Result Events.  It contains Event ID, Level, Gender.

I have a table called Results. It contains the fields User ID, Event ID, Result.

 

What I would like to do is have a value list (a pop up menu) which only shows user IDs which are in the same level and gender as the event ID (eg if an event is Male, Junior,  the value list in the table results will only show users which are Male Junior)

 

Any advice would be greatly appreciated. I am stuck and can not get it to work - I have been looking on various sites and not be able to find a solution.

 

 

Thanks!

[webko]

Set up a relationship between Result Events and Users which is based on both Level and Gender being equal.

 

Set up the value list in Result Events using this relationship.

[Tim Hampton]

When I do this I get the error: <no values defined>