locked
creating a 'watch list' of items RRS feed

  • Question

  • User-41063278 posted

    If I have an Access database with two tables, called 'Users' and 'Items', what is the method to create a watch list, so a user can login and see the list of items they have chosen to watch (as you can in ebay for example)?

    I thought the solution might involve using code to modify the relationships between the two tables, but am not sure how this would work in practice.

    I've searched for answers, but have not made any progress, so I would appreciate any help.

    Thanks, Gavin.


    Thursday, January 6, 2011 9:47 AM

Answers

  • User1867929564 posted

    You can create table like junction.
    you can allow user to remove item. if volume is more then you can restirct no. of item chosen by user.

    Other possibility is xml.
    I can't think of other way.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, January 19, 2011 5:29 AM

All replies

  • User187056398 posted

    You need a many-to-many table, also called a junction table.  With these fields:

    ID  UserID   ItemID 

    Thursday, January 6, 2011 10:16 AM
  • User-41063278 posted

    That sounds like the best method.

    Obviously if you had a large number of users watching a lot of items each, the junction table could potentially become quite large in terms of the total number of records:

    (total no. of users x avg no. of items watched per user)

    but the low amount of memory needed for each record in this table would compensate.

    Thanks for your help.


      

    Thursday, January 6, 2011 11:09 AM
  • User-2115483147 posted

    How about use a XML to description the items and save the XML to database.

    Wednesday, January 12, 2011 11:59 PM
  • User1867929564 posted

    You can create table like junction.
    you can allow user to remove item. if volume is more then you can restirct no. of item chosen by user.

    Other possibility is xml.
    I can't think of other way.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, January 19, 2011 5:29 AM