Here's what I'm looking to do:

Have a masterlist of all records within a given recordset.

Allow the visitor to click on any of the hyperlinked records which in turn, takes them to the viewpage.asp where they can view the specified record.

Then I wish to have included on this viewpage.asp a checkbox where they can tick it so they can ADD this record to their profile (another table within the database).

How would I do this? Would I add a 'Add Record' server behavior to the viewpage?

I'm lost and need help!!!!

Thanks

Frenzy

Hi! What I would do in this case is have another table called "TBL_SAVED" or something like that. Instead of the text box, just have a button with "save in profile" on it. When submitted insert the following details into your new table called "TBL_SAVED".

TBL_SAVED Fields:

SAVE_ID - Autonumber
SAVE_USER - Number field (Referential integrity with your users id key in tbl_users)
SAVE_PAGE - number (id of the page that was saved)

Insert the user number, and page they want to save into this table as a new record for each one they want to save. When they want to view saved data, retrieve the list of page ids from TBL_SAVED and filter on this users id.

I hope that helps you. That's the basics, but you can expand on that and should give you a good basis to start from.

Regards,

Dave <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>


_________________________
WinXP : IIS 5.1 : StudioMX : ASP : VBScript
www.clicksdesign.com