Here is the layout: Property management database, where a single property may have up to 50 different and unique amenities. I would like the ability for the end user to first, create the main property details. Second, add the various amenties on one page with a dynamic table, using checkboxes to add that amenity.
Database Structure:
1st Table: TBLproperty (propID, prop(many other fields with address etc)
2nd table: TBLamenities (amenID, amendetails) only two fields
3rd Table: Join table between the above two. amenLIST (propID, amenID)
The form process to add a new property is multi-stepped. Formpage1.asp - Add the Main property details such as name, address, phone etc. Upon submit, get last recordID from database, and go to Formpage2.asp. Formpage2.asp retrieves the new record from the TBLproperty table, and sets the propID value to a hidden form element. TBLamenities is queried, and using a form checkbox tied to the value of "amenID", a repeat region is created on the table and a submit button placed at the bottom.
This is where my plan comes to a screeching halt!! Can anyone provide a good tutorial location, where I can figure this out?
Thanks in advance...
Read More