Over 46,000+ Business Solution Developers Find answers, ask questions, and connect with our community of business solutions developers, business owners and partners.
For example, in InBizness SOHO, we have a contacts file. As we know, a company in the role of a client, vendor or sales lead may have multiple contacts within their organization. The contacts module is designed to allow you to have an almost unlimited number of contacts associated with the above companies or independent records of their own.
So you could say that the contacts module has a mandatory relationship to either a client, lead or vendor. But then you might want to have an interface to the contacts module for contacts with competitors, associates or members of your Rotary Club.
You may have a phone number table, that allows you to have multiple phone numbers for a contact. So you would likely never have a phone number record that isn’t related to a contact. So this would be an example of a mandatory relationship type.
You may also have a business rule that defines the relationship type. You might say that a lead record has an optional relationship type to a sales rep record in the staff table. Leads can be imported into the database and later assigned to the sales rep you want to work on them.
You might say (as a business rule) that there is a mandatory relationship between clients and a sales rep record in the staff table. So a sales rep record cannot be deleted until all their associated client records are re-mapped to an existing sales rep.