Trying to build a tracker to keep track of new features being released and which client/groups have been notified of the new feature.
Table 1 is called “Features” which will have all new features added.
Table 2 is called “Client Groups” which have all the clients added.
I ideally want to link Features and Client Groups in a way that every time I add in a new Feature, all of the Client Groups would be nested/grouped beneath on a separate row.
Looking like this:
That way I can set up columns that I can check off for each client that received a notification of each respective feature
Ideally, every time I add in a new feature, that nested grouping of Client Groups beneath would just automatically happen
Welcome to the community, @Evan_Komar!
You can achieve this by creating a 3rd table which is a “junction table”. This table acts as the “intersection” between clients & features. You would do all of your grouping and checkmarking in that table.
This is called a many-to-many relationship, and is explained here:
But in the third table, would I manually have to select the Feature in one column and then select the Client Group in another column multiple times?
So for example it would look something like, where I’m manually selecting all of these:
Feature 1 - Client 1
Feature 1 - Client 2
Feature 1 - Client 3…
Feature 2 - Client 1
Feature 2 - Client 2
Feature 3 - Client 3…
Or is there a way to have a feature paired with a client group on a different row without having to select them all manually?