AnsweredAssumed Answered

Conditional lists

Question asked by weedonpaul on Jul 23, 2012
Latest reply on Jul 23, 2012 by philmodjunk


Conditional lists



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?