Hi everyone!
I'm using a portal to manage my members of staff who work for me like: assistants, makeup artists, producers, etc.
I have two fields in this portal called "Type"(drop-down menu) and "Name"(drop-down menu) which means that in the"Type" field i'm placing the type of staff (makeup, producer, etc.), and in the "Name" field i'm placing the name of the staff related to that type of work.
Now, i do have a table just for my staffs registration, and what i want to do is; when i select the type of work in the "Type" field, in the "Name" field would appear only the names related to that type of work. For example: If i select in the "Type" field "Producer", when i'll click in the "Name" field it will only appears all the names of producers that i have register in my Staff Registration Table.
Please, i've tried to do it, but i only could make it appear all the names of my entire Staff Registration Table.
I'll be very very glad if somebody help me! Please!
Thank you for your time!