AnsweredAssumed Answered

Where should this field info be stored?

Question asked by Robert Sinclair on Dec 11, 2018
Latest reply on Dec 12, 2018 by Alex Nassi

Very simple question, hopefully I won't overcomplicate it:

 


There's many to many relationship between users and accounts and there's a field called "commissions".

 

When John is assigned to account (A) his commission is 5% when John is assigned to account (B) his commission is 14% and when Bill is also assigned to account (B) his commission is 10%.

 

So where would this "commission" info be stored?

 

It can't be in "users" or "accounts" module, so would I make a column in the relationship table that links the 2? Or is there another way of doing this?

 

Hope this makes sense

Outcomes