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

Try committing the record immediately after duplication.

Hello and thanks for the reply.

I probably didn't make myself clear. I want this to work when I click new record. Currently they only work if I duplicate a record.

Thanks Dave

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?

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

SupTracking2.0.fp7.zip

Why wouldnt you just you a button to script a new record?

I could do that. So what would I do in the script to tell what FLM's employee's I want to see? Use a variable to set it?

Dave

Yeah why not. Just capture the ID in a variable, create the new record, set the ID and commit the record.

That works great. I guess the more complicated you make a database, you must make sure that you customize things as simple as a new record request, to ensure everything works as expected.

Thanks Dave