ok, i just typed out a massive scenario so you guys could help me out and eneded up semi-answering my question!
However... a table contains 8 blank records. In the management system controlling that table there is no add delete or edit function... just a 'view record' function and a 'replace record' function.
The replace record function is my problem!! I want to be able to click the replace record and be taken to my main table containing all my records and be able to select a specific record and say 'use this record' then be taken back to the initial table with the 8 blank records... where the record i clicked 'replace', has been populated with the new record i selected from my main table. Basically a browse button for records, and instead of edit record it says 'replace'.
I want this for a featured product system, where there is a fail safe system that allows a user to add 8 featured products and no more! And this table to be displayed at the start of the online store product page!
I cant seem to think of a way this system could be implimented into the main table management system, as more than 8 products could be selected as a featured item (as this would be an option in the add pages). Therefore, i thought if i have a set 8 records with no add or delete, there would be no way of adding more than 8!
OR....
Can i condition an option in the add.asp where the user types in 1 - 8 for priority of fetured product, and if another record in the table has that particular number it prompts to delete the old number from that record, or leave it alone and the user must type a different number!
If you can help me with my problem of the record browsing and populating to another table! thank you!! or if you can think of a stupidly simple way of implimenting this system better! thank you!
Joe