Formating a Results page in FP2K & adding info to results

[MysticKnight]

I actually have 2 questions.

#1 - Is there a way to change the format of the
information that's posted from a form? I know you can
change the page format but I'd like the actual
information submitted to look different than the
standard. For example; this is my current results page:
http://bloommusic.com/FormTest/formrslt.htm . I'd like
the results page to look more like this:
http://www.bloommusic.com/gigs_3.htm .

#2 - I'd like the person using the form to be able to
select a location from a pull down. That's simple enough.
Is there a way to have the form post more than what's
shown on the pull down to the results page though? I'd
like the options on the pull down to be the names of
different venues for the band but when the form is
submitted I want the venue name AND ADDRESS to show up on
the page.

Thanks to all and merry X-mas!

 

[Jim Buyens]

-----Original Message-----

I actually have 2 questions.

#1 - Is there a way to change the format of the
information that's posted from a form? I know you can
change the page format but I'd like the actual
information submitted to look different than the
standard. For example; this is my current results page:
http://bloommusic.com/FormTest/formrslt.htm . I'd like
the results page to look more like this:
http://www.bloommusic.com/gigs_3.htm .

You would have to write a custom page in ASP or ASP.NET.

#2 - I'd like the person using the form to be able to
select a location from a pull down. That's simple
enough. Is there a way to have the form post more than
what's shown on the pull down to the results page
though? I'd like the options on the pull down to be the
names of different venues for the band but when the form
is submitted I want the venue name AND ADDRESS to show
up on the page.

Again you would have to program this in ASP or ASP.NET.

Normally, you would post only the date and a venue ID to
a database, Then, you would have a separate database
table for venue details like address and phone number.

For reporting, you would then match the location ID in
the gigs table to the venue ID in the venue table.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------