So why are you making it so complex?
Have them go to a form and select a location
- takes them to a page to select a survey to fill out (any one of the 5 surveys)
Save the location selected as a session variable (or pass if from form to form as a hidden form field variable)
In each survey result record the session variable for the location selected
- or if other data is required from location table open that table (based on location ID) and get the field data to add to the form
as hidden form fields
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________
| Thanks for sticking with me on this. I've been up all night trying to figure
| this out.
|
| Location code is a 5-digit alpha/num value unique to each of our sites (ex.
| GA001).
| An IT person will be responsible for filling out each survey and the
| location code will be entered for each entry.
|
| Every survey has the location code listed as a required field. Most likely,
| all sites will have some information to enter on each survey but not
| necessarily for every field. Some questions may have more than one answer so
| there might be several rows listed for one site for one question i.e. names
| of servers at that site.
|
| The same 5 surveys will be sent to all sites and the data compiled and
| reported against.
|
| Thanks, again.
|
| Karen
|
| "Stefan B Rusynko" wrote:
|
| > You have still not defined (explained) what relationship location has to any of the 5 surveys (if any)
| > - and what information you are using from location in the surveys (some preset fields w/ values assigned based on location
"code")
| >
| > Are the 5 surveys unique to each location, or are you just using the same 5 surveys and tracking which location responded in
each
| > survey in the results (adding data to the response saved to the survey from the location table "code" selected)
| >
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| >
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | > | I'm sorry - I'll state what I would like the results to be instead of how I
| > | thought I might have to attack this:
| > |
| > | I have several tables in an Access db that represent surveys to be completed
| > | by the company sites. They are linked by a location code.
| > |
| > | Upon opening the survey page, I have been asked to show a site location code
| > | dropdown and after choosing a particular site and hitting "Go" the first
| > | survey form, "Survey1" will open. I have created an Interface and a search
| > | file for each table/survey. Each form allows editing as well as showing
| > | existing data.
| > |
| > | Back on the initial page, I need to have a link to the other surveys, and
| > | upon clicking, Surveys2-4 will be visible and populated information that
| > | applies to the location code chosen in the first dropdown.
| > |
| > | Hope that makes more sense.
| > |
| > | Thank you,
| > |
| > | Karen
| > |
| > |
| > |
| > | "Kevin Spencer" wrote:
| > |
| > | > Hi Karen,
| > | >
| > | > Anything is doable. But I don't know what exactly you're doing, or more
| > | > accurately, how exactly you're doing it.
| > | >
| > | > --
| > | > HTH,
| > | >
| > | > Kevin Spencer
| > | > Microsoft MVP
| > | > ..Net Developer
| > | > A watched clock never boils.
| > | >
| > | > "Moving rpts from Access to Rptg Services"
| > | > message | > | > > Thank you. Will this be doable pulling the data from several
| > | > > interface.asp
| > | > > search files I created, tying all back to the location codes:
| > | > > first dropdown has location codes listed, the next has the interface files
| > | > > (surveys) and then the survey data detail will show for the chosen
| > | > > location
| > | > > code....the detail file is editable.
| > | > >
| > | > > Karen
| > | > >
| > | > > "Kevin Spencer" wrote:
| > | > >
| > | > >> Hi Karen,
| > | > >>
| > | > >> Don't be too hard on yourself. Sounds like you've come a long way on your
| > | > >> own!
| > | > >>
| > | > >> Here's a link to a tutorial that explains how to populate a drop-down
| > | > >> from a
| > | > >> database query, using FrontPage (and a bit of hand-coding):
| > | > >>
| > | > >>
http://frontpagehowto.com/dynamicdrop/default.asp
| > | > >>
| > | > >> --
| > | > >> HTH,
| > | > >>
| > | > >> Kevin Spencer
| > | > >> Microsoft MVP
| > | > >> ..Net Developer
| > | > >> A watched clock never boils.
| > | > >>
| > | > >> "Moving rpts from Access to Rptg Services"
| > | > >> message | > | > >> >I have created an Access database containing site locations, employee
| > | > >> > information table and 5 site surveys that has been imported to Front
| > | > >> > Page. I
| > | > >> > need to have a dropdown populated with location codes that once chosen
| > | > >> > will
| > | > >> > open the corresponding Survey1 and have links/buttons to the other 4
| > | > >> > surveys
| > | > >> > - and at opening will open the detail for that site.
| > | > >> >
| > | > >> > I was able to do the first part (although the code would make a real
| > | > >> > programmer shudder). I know there is a better way but need help to
| > | > >> > find
| > | > >> > it.
| > | > >> > I hard-coded the data for each option in the dropdown and used a Go
| > | > >> > button
| > | > >> > to
| > | > >> > go to open the first survey detail for that location. It works but
| > | > >> > it's
| > | > >> > not
| > | > >> > the most efficient way to do this.
| > | > >> >
| > | > >> > That's as far as I have been able to go. I'm not sure how to attempt
| > | > >> > getting the GO button to also open the links to the detail info for the
| > | > >> > other
| > | > >> > Surveys for the chosen location - on the same page.
| > | > >> >
| > | > >> > Thanks - hope this made sense.
| > | > >> >
| > | > >> > Karen
| > | > >>
| > | > >>
| > | > >>
| > | >
| > | >
| > | >
| >
| >
| >
