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?