ziceg

Conditional Value List to show only Active

Discussion created by ziceg on Sep 28, 2012
Latest reply on Oct 6, 2012 by ziceg

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

Outcomes