I want to create a filter system for the data base.
I have several tables but this only effects 2. Table1 is Customers, Table2 is Contacts ( i am a small pr company) I currently have 10 customers (call them CustA....CustJ)I also have 12000 Contacts that I have picked up over the years. Some contacts a relevent to some clients and not others whils are only relevent to a client some of the time.
I want to be able to have a tick box on each contact that allows me to select multiple clients that the contact is relevent to. depending on which contacts I select another list will allow me to select a sector
Example. CustA has several sectors (consumer, IBC, Nationals, uk,) CustB has (satellite, medical, TV) CustC has (wildlife IBC Legal)
Now I have a contact that is relevet to CustA in the sectors IBC and UK and relevent to CustB in the sector TV. I would like to be able to tick the boxes CustA and CustB and the second list change to list onlty the sectors relevent ie. Consumer, IBC, Nationals, UK, Satellite, medical and TV
Is this at all possible?