Jump to content

Value List Question


This topic is 5768 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am trying to figure out how to handle this problem, and I am sure the experts on here know the answer.

I have a layout that has a value list to select the employee.

The value list shows related values based on a table that filters out employees that are not mine. So when a Supervisor goes to the layout and makes a record, when he selects an employee, only his show up. The Supervisor may have 13 employees, but if i didn't do this, all 350 would show up in the pop-up list.

If I am looking at one of the records and duplicate it, then go change who the employee is, I see only my employees. When I click on new record, which is what I would really want to do, I get "no values defined". Obviously filemaker has no idea who the supervisor is now, so it can't give me any data.

What is the proper way to do this? I can't figure out a way to make it, so when I click new record, it still remembers who the supervisor is.

Thanks Dave

Link to comment
Share on other sites

How is your relationship for your value list set up? Are you using a global field to store the current supervisor? Any other info you can provide?

Link to comment
Share on other sites

Well let's see.

I have a FLM(supervisor) table

an employee table

and an evals tables (used to store the employee's evaluations.

When on the evals layout (based on evals), it will show all evals for my employees. I am not using global fields for this, but when I click on the evals table, the script will look and see who the FLM(supervisor) is on the layout I am on and go to the evals table, search for only that FLM's employees.

So if I am looking at a record for John, and click in the name field, I see all of my employees.

Using a value list of fk_employee and name, showing only the name, and based on a table that will show only employees for a certain FLM.

So when I hit new record, all values are gone, and up comes "no values defined" when I click in the field.

I have attached the file so you can look.

Go to the FLM layout and find David Chappuies, then click on the evals tab at the top. When on this layout, try to make a new record.

Any ideas would be greatly appreciated

Thanks Dave


Link to comment
Share on other sites

This topic is 5768 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.