I have a list of projects. Inside the project list you can select a Client. I have a list of Clients.
I have another list, a list of Contacts, they have a lookup column called Client to specify from which Client this contact is from.
In my project list you can select a Client, i want to be able to also select a contact that is from the list of Clients that was selected.
How can i managed this ?