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