RocketRod wrote:Further explanation.
I would pursue my original concept. It doesn't matter how few attributes you have in the master table but it's important that you at least put the industry there. Also to retain a master table simplifies your coding a lot. To the user they don't see any issues say in creating an item as you would use a process.
Create master with master.industry = users industry
Edit master
You then have just one Edit form for the master with each industry having its own form section based on applicability of the mater category. The industry form section displays the information as a form as these reference attributes would not have multiple ticked on for the reference. Yes the count of the master table would be large but it would be small in size.
This enables you to write one query, one add, one edit rather than a set for each industry.
I'm not sure why you require a m-2-m middle table? Maybe you could elaborate as I would just see subscriptions as another reference for the mater table?
Cheers Rod
Thanks Rod;
I need to think through the cases since each item for each industry becomes a child of a single master record for each vendor, rather than an standalone record in the it's own industry table under the vendor. Every time I need to deal with a record I first have to bring it's single parent master record into context and then fetch all it children.
For example, to create MasterBO
LoggedInUser.Industry = 'Aviation'
LoogedInUser.MasterBO.Industry=LoggedInUser.Industry
Then anytime I need to create a new AviationBO, I first have to bring it's parent into context by finding it and then assign the parent to child.
AviationBO.Parent=MasterBO
But from this point, anytime I need to find any AviationBO, I have to have to find the master for that user and then find an individual child.
Thinking out loud...
Then this raises the question, if I only have ONE masterBO per user (since a user only has ONE industry), why do I even need a MasterBO? I can make the user as the masterBO and all AviationBO hangs from a user and not a middleman, like MasterBO.
I hate middleman, they always get in your way.