Hmm...based upon the .zipped code I stuck up and the new 'checkbox' column/field approach, this is how perhaps it should work.
PAGE 1:
Reads from the one table and displays a "Master List" of choices to include a blank checkbox.
When one or more checkboxes are checked and the Submit button is clicked, the appropriate row cityname gets a 'yes' put into the 'checkbox' column/field.
Then, I am transferred to...
PAGE 2:
This displays a condensed/summary list of ONLY those citynames which have been checked 'yes' (from the same one table). If an addition or deletion needs to take place before a "Final Process" (Submit) button is clicked, a 2nd Submit button called "Revise" would take me back to Page 1 ... but to display ANY checked items to date.
PAGE 3:
This is a standalone page with the 'Drop Down' list which ONLY displays 'checked' items from the ONE Table used for everything.
But here is the catch...whichever cityname is selected, I will need to pass both the 'taxrate' FOR THAT 'cityname' selected on to some other script or cart. But I don't know how to configure the 'hidden' tag so this will happen. Would that involve either a $row['ID'] ... or ... the 'cityname' associated with it to work?
The only other thing I can think of would be to have the choices/options display as 'Radio Buttons', but if there are 10 or 15 choices, this could be more messy than a drop down list.
Actually, now that I think about it, 'cityname' will actually be comprised of entries for:
- City (Name)
- County (Name)
So the way it is supposed to work is that if a person lives in one of the displayed Cities, they would click that Radio Button and then Submit.
BUT, if they do NOT live in a listed City, BUT live in one of the displayed County (Names), then it is the County name Radio Button which must be chosen. And then...
Finally, if they are NOT in one of the Cities OR Counties, then a final option of: (radio) Base Rate must be chosen.
If I take the Radio Button approach, then I could put specific instructional text right above each 'section' (although it is really all contained within ONE 'form' to be submitted.
Hmm... now I'm thinking it would be a 'cleaner' page to have 2 Drop-Down lists and I can put the same Instructions above each drop down list. Like: Choose one of the following cities. If you do NOT live in one of these cities, proceed to the next section.
Then, in the 'County' (Name) drop-down, instructions like: Choose one of the following counties. If you do NOT live in one of these counties, proceed to the final section.
There, could be one 'Radio Button' option saying: State Base Rate.
OR, if NO City is selected and NO County selected, then the Value for passing on would be a predetermined "State Base Rate".
Umh, perhaps a separate entry in the 'Master Table' of City/County names could be: State Base Rate...and then this could be read from the Table directly into the Page 3 display.
Thanks again for the assistance.