Advanced PowerPrompts

[andrewpaul]

I've been able to get PowerPrompts to do some pretty crazy stuff in the past but this latest request might be tad too far fetched.

Basically I need to have 1 page vs. several cascading pages. All the pull-down menus on the first page need to be related by way of their normal data relationships. That is, if I select one entity in one drop-down, then other entities that are not dependent on the first should dissapear and not be available via the other menus. I know this type of dynamic html is possible via Javascript as I have sample code that does it.

My theory is that I could dump all the data into Javascript arrays on the page. This would mean one big query or several smaller queries. At any rate, how would one get Oracle to come back with recordsets for 8 different pull-down boxes and you be able to make some semblence out of what data is a part of what?

On the database query end, I'm thinking that I would need n!/(n-2)! for n menus being related by pairs (representing n dynamos since each menu needs one). That comes out to 12 seperate combinations/permutations of any 2 menu dynamos (4!/(4-2)! = 12).

Any ideas on if this is the right way to do this?

 

[rcaesar]

Hi AndrewPaul:

I have worked with powerprompts for a while, but still struggling with it. From what I have read so far (not tried it), it is possible to have the prompts in one page if you use frames. You can use borderless or invisible frames for the prompts and I guess show/hide the frames you want.

As a related question, I hope you can also help me:

I have two tables, say Contracts and Deliverables.

Both are joined (1 to many) and the Contracts table also has an outer left join with another table.

Now, I have created a set of prompts (Status and Manager). Both of these prompt values come from the Contracts table. The report itself has fields from both tables. The problem I have is in the construction of the ADODB SQL.
Do I have to specify the joins in the SQL? The prompts run fine without specifying the joins, but the report does NOT run.

In the past, when I was retrieving data from one table, the prompts and report run fine with no problems.

Do you have any suggestions?

BTW: I am not using Dynamos at all. I have built the prompts using HTML/JavaScripts.

Would appreciate any help.

Thanks

Ram