So i can get each user to see their own fields. but what i would like to do is assign those fields to a supplier ID and when the supplier logs in they can see those fields assigned to them. the catch is the users must still see their own fields.
what i basically have set up is an application Table. these applications are assigned to users to contact clients, once the data is filled in an administrator can then assign the application to a supplier to fill the order. i have set up a field supplierID but i cant get the fields to display by userID and Supplier ID,
ie display all fields where userID is equal to current userID And supplierID is equal to current Supplier ID
Thanks in advance Ryan