User-defined list

[durendal4444]

Hi guys! I'm a new developer and I'm just stumped after a week and a half of research.

What I'm trying to do:

I have a huge number of titles listed on my site and each one has its own page. I want to provide an "add this title to your list" link from each respective page to a list defined by a logged in user with all of the titles they own or want to own. Then each time they log back in I would like to have the list available to them. I just can't figure out how to do it. Would it be possible to create a new recordset for each user? Maybe I'm talking crazy.

ANY help would be very much appreciated! Thanks!

[Alan]

You could create a many to many relationship between 2 tables in a database. The two tables would supposedly be a users table and a table with all the titles. That would be one way.

You could also store a serialised array in the users table of all the titles in their list.

It would be easy to update the list and display it as you needed using those methods.

There are other ways but those two are probably the best options from the ones in my head. :-)