Forum Documentation Showcase Pricing Learn more

Best way to set up data with cross references

I have 3 lists

  • Groups
  • Categories
  • Transactions

Here is a visual example of each:

Groups:
Group (Unique)
A
B

Categories
Group (Type Group) | Category (Unique)
A ---------------------------------- 1
A -----------------------------------2
B -----------------------------------3
B ------------------------------------4

Transactions:
ID (Unique) | Category (Type Category) | Group (Type Group)
a1 --------------------------------3-------------------------------B
a2---------------------------------1-------------------------------A
a3---------------------------------4-------------------------------B

My set up is within Category, Group is linked to Groups and within Transactions, Category is linked to Categories and Group to Groups.

The user assigns each transaction a category.

I want to ensure that Group gets assigned accordingly for each transaction. I know how to update group when category gets assigned.

Is there any other way to ensure data integrity of Group within Transaction? Like, within Transactions itself somehow?Preformatted text