Hello,
I have a list which has 7 Cascading Drop Downs. Multi select wont work for a number of reasons.
I'm trying to accomplish 7 similar CDD's but between two tables with no direct connection (no foreign key). The tables are related through several joins. I ended up creating a table (based on a view), with a PK comprised of three columns. It works for 1 or 2 CDD's but starts taking a huge performance hit after enabling 3+. With all 7 enabled, the list never responds.
As I said the list I want to reference does not contain the foreign key of the watch element. Is there a way to use CDD with a additional Joins (I'd need 3).
An alternative, I think, could be using the databasejoin element and getting creative with the WHERE clause, using Select's and Joins inside it. However, I'd have to be able to get the real-time value of the watch element, and I'm not sure that's possible. Also would have to have the element refresh when the watch element changed. Any of that possible?
I have a list which has 7 Cascading Drop Downs. Multi select wont work for a number of reasons.
I'm trying to accomplish 7 similar CDD's but between two tables with no direct connection (no foreign key). The tables are related through several joins. I ended up creating a table (based on a view), with a PK comprised of three columns. It works for 1 or 2 CDD's but starts taking a huge performance hit after enabling 3+. With all 7 enabled, the list never responds.
As I said the list I want to reference does not contain the foreign key of the watch element. Is there a way to use CDD with a additional Joins (I'd need 3).
An alternative, I think, could be using the databasejoin element and getting creative with the WHERE clause, using Select's and Joins inside it. However, I'd have to be able to get the real-time value of the watch element, and I'm not sure that's possible. Also would have to have the element refresh when the watch element changed. Any of that possible?
Performance is good too. I see it helps to know what you're doing!