AnsweredAssumed Answered

3 tiered conditional value list

Question asked by petergraham on Aug 30, 2012
Latest reply on Aug 31, 2012 by philmodjunk

Title

3 tiered conditional value list

Post

 Hi all

I have 3 drop downs on a portal form and need some help getting the third drop down working.

The first drop down simply lists all values. This is all elements of a building for example, doors, windows, roofs etc.

The second drop down then lists the sub building element, for example if doors is selected in the first option then all the different types of doors is brought back eg hardwood, softwood, pvc doors etc.

The third drop down then lists in detail what is selected in drop down 2. For example if hradwood door is chosen it will list all the available hardwood doors.

The first two drop downs work fine but the the third just doesnt work.

The first table is linked to the second table on a unique building id so table 1 building id = 1 is linked to table 2 bulding id =1. For example doors has a id of one and in table 2 all the diff types of doors have an id of 1. These two drop downs work fine.

The third table is linked to the second table via a sub building id. So, table 2 sub building id = 1.1 is linked to table 3 sub building id = 1.1.

All 3 drop downs are on a portal.

Ive spent 2 full days trying to crack this when im sure someone with more expertese could crack it straight away.

Any help would be greatly appreciated.

 

Thanks

 

Pete

 

 

 

 

 

 

 

 

 

relationships.jpg

Outcomes