John, The other option is to populate your fields using javascript. That approach is not as straight forward but avoids the overhead of performing the submit. There is a lot of information available within the OTN APEX discussion group (*http://tinyurl.com/gj92p) *on this. See * http://tinyurl.com/2pl3rw* for an example of something similar that Carl Backstrom has done. On 9/4/07, Bill Ferguson <wbfergus@xxxxxxxxx> wrote: > > Hi John, > > Sounds like you want to change to a "Select List with Submit". > > In HTMLDB (actually called Application Express, or Apex now), nothing in > your user enterable text fields has a value until the page is submitted. > > You can also create an OTN account (if you don't already have one) and use > the Apex forum for these questions. It's a very good place to start. The > address is http://forums.oracle.com/forums/forum.jspa?forumID=137&start=0 > > Bill Ferguson > > > On 9/4/07, Weatherman, John <John.Weatherman@xxxxxxxxxxx > wrote: > > > > All, > > > > > > > > I have recently started playing with HTML-DB and, while most of it seems > > straight forward, have hit a wall. I want to be able to pick a value > > (hostname) from a dropdown and have all the other values from the base table > > display. Getting the dropdown working is easy enough, and if I use the > > "Step" tags under the dropdown, everything works, but I can't seem to get > > the dropdown itself to trigger the rest of the fields to refresh. > > > > > > > > Has somebody worked with HTMLDB enough to explain how to do this? I've > > tried the docs and can't seem to find it. I am on 10.2.0.3 and > > unfortunately the books outside the docs seem to be for 9i. > > > > > > > > TIA, > > > > > > > > John > > > > > > > > > > > > John P Weatherman john.weatherman@xxxxxxxxxxx > > > > Sr Oracle DBA Desk: (615) 762-1376 > > > > Asurion, Inc Mobile: (615) 517-2831 > > > > > > > > > > -- > -- Bill Ferguson -- Rumpi Gravenstein