Posted by c
2014-05-29

I have a number of users (staff) that I've added and as you know each of these have staff_Id. I would like the search form for customers to automatically use the staff_Id as a search parameter when each staffer logs in. I have added the staff_Id to each customer record such that when a staffer adds a customer I populate the staffID field in the customer table to match.

I just want the logged in staffer see only those customer records using the ID in the customer table without being able to edit the ID. It's good to show his ID in the search area but not let it be editable.
Posted by Tom
2014-05-30

First, create a search input box for staff_id and make sure you can select the customer records with a particular staff_id. Then assign the staff_id of the logged user to the search input box, so the user will see only customer records that have the user's staff_id.