I'm doing a system of commissions in which I have three tables:
tabla 1 "administrador"
id
codeEmpresa
empresa
tabla 2 "cominicionista"
id
idEmpresa
nombre
categoria //la categoria puede ser A, B o C
tabla 3 "cliente"
id
nombre
categoriaCliente //la categoria puede ser A, B o C
Explanation: each participant has a client or several and each client can have several commissioners since there are several categories. What I do not know is that how to relate them. I try to make the commissioner see the clients of his category and that the clients can see their comicionistar depending on the category and that is what I do not know how to do. The company can enter the comicionistas that wants and also can enter the clients.
At first, I happened to put in an array () all the categories and somehow when I do a SELECT to do them with the array, but I do not know how to do that .... je
I hope you help me