Conditional Value List to show only Active

Discussion created by ziceg on Sep 28, 2012
Latest reply on Feb 19, 2018 by jdevans

Hi, I know this has been discussed ad nauseam before, but I'm getting so confused I still can't get it to work for me... Sorry


Can someone help me in simple easy words....


I have a table Employees with Fields (Record ID, Name, Surname, Active)


I want to create a value list that I can use in man other tables later on where I will need to select from a value list which Employee I am assigning things to eg Equipment. But I only want to be able to see in the value list the ACTIVE employees.


I have set Active field to receive its value from a checkbox that comes from a value list "1" so that if it is checked it becomes "1"


Here is were I'm stuck....


If I go to relationships and create another table "Employee_Active" what do I link to what? How do I tell it to only look for the "1" in the Active fields? (Do I link "record ID" from original to "Active" in double up?


If I go to create a value list and try to Use values from field... what exactly do I do? at which point can I point it to only show me the results of Active=1?


I know it's got to be really easy... but I'm a very confused cookie