How to do user-created lists/sets/collections of records?

I have basic knowledge of access but I don’t know the best way to go about doing this:

I have a table “Objects”. I want users to be able to create custom “lists” (sets, collections, etc.) and then add individual records to those lists.

Right now all I can think of is creating a new table for each “list” and then adding records to the list via a unique identifier and a relationship to the Objects table.

This could work but would end up with a ton of tables if a lot of “lists” are made. Is there a better way?

submitted by /u/stillnotmakingsense
[link] [comments]

Posted on