I'm creating a Support Center which will contain multiple types of support, as well as multiple categories. Types will contain entities like Tutorial, doc, tricks etc. while the category will contain entities like orders, delivery, payments etc.
I've already built the structure, but I'm not sure as to which approach would be favourable here.
- Create one collection called 'Articles' and create two other tables called 'categories' and 'types'. Every article has two fields that reference to which category and type this particular article belongs.
- Create one collection for every type of Article, and just use one reference field to attach this particular article to a certain category.
My logical thinking would say 1 is best, but there's a minor problem with that approach:
On the homepage, I want to show two dynamic lists. One shows tiles for every type of support, with a list of articles belonging to that type. The other one shows tiles for every category of support, with a list of articles belonging to that article.
The problem: It is not possible to nest dynamic lists to put a list with articles in every tile for category & type.
Am I right in the above description? If I am, is approach 2 the solution to this problem?
Thanks for your insights guys!