I’ve created a customer database that lists each of the periodicals my customers are subscribed to. Sometimes, a customer subscribes to periodicals by a grouping. For example, they might select “Gaming” as a category which means they want a selection of 4 periodicals about gaming. Not all customers subscribe this way though, so right now I’m using a field linked to a list of periodical titles and I add their periodicals individually, but this means I (and my staff) have to know in our heads which titles “Gaming” refers to.
Would it be possible to somehow link to a grouping that would populate this field with periodical titles? Would it have to be a separate field since the current one links to individual periodical titles (and most customers do subscribe this way)?
I hope this makes sense. It’s so hard to discuss database relationships abstractly! Thank you for any help you can provide!