Asp form connecting to Access

Dear All
Happy new year

I run the site http://www.easytraveller.gr where I have several asp forms to display the rates of hotels and where someone can make reservation. One of the forms is http://www.easytraveller.gr/andromeda_villas_santorini.asp
In this form I use the recordsets to get info from an access db:
rsRates, rsRooms, rsMonths, rsDays, rsYears, rsNights, rs Persons, rsCountries. In all forms all above is the same except of the rsRates and rsRooms. These 2 recordsets take info from 1 table which is unique for each hotel. When I make the form I specify to the recordset in which table to go and get the info but as you see I have to make about 700 forms. The name of each form is specified in the link button of a page made in flash like: geturl
andromeda_villas_santorini.asp.
What I need to make is: One single form named hotelres.asp with all the recordsets as above where I could specify for every hotel a special code corresponding to the table containing the rates and room types. So I have in the database 1 table for each hotel and 1 form that will be looking for the information to the relevant table according to the information provided in the linking button.
Thank for every one who can help
Best regards
Tolis

could you not:

• Have a drop down box, and loop through the hotels you choose from, leaving their ID as the value of that selection...
• say the user clicked the first item in the dropdown, (the id being 1), when the form is submitted, you select the rate from the second table (finding it with the ID from that dropdown)

from there it should be straightforward...

if you need additional help feel free to ask..

Thank you Benbramz

Sorry but for my knowledge level this is not clear. If you can kame it more clear I will very much appreciate, or if someone has any other idea?

Best regards
Tolis

hey thats no problem...anyway, i was wrong about what you needed....

what would be better is:

you have one page, instead of having *andromeda_villas_santorini.asp* and 100's like it, you have showresort.asp.

however, we will use somthing called a querystring. these are the things that usualy look like id=76637 etc. To start these off, we have a ?. so showresort.asp?id=76637

follow so far? hope so

anyway, what we will do is select the information from your database which has the resorts in, by using this quesrysting (using ID as the matching ID of the record)

so, to start

Code: Select all

<%
recordID = request.querytring("ID")
if recordID  > "" then
'if there was an ID, then we would carry out our prosessing here..
else
'this is what we do if there is not an ID on the link...
response.write("error!")
end if
%>

then on our sql statment we would get the script to select the records from the database which has the ID in the querystring...
recordset.Open "SELECT * FROM tablename where ID=" & recordID
see?

if your looking at the screen like , or even then add your file in a zip archive and ill be happy to edit it accordingly... or post up the code of your file if thats easier...

Thank you Ben
Your help was great
Tolis

glad i was of some use!