I am currently developing an MVP for my start-up and I want to make it so my Enterprise customers have a custom ID for their customers to use so they can only be matched with them for Service calls. How can I do this on a database level?
I’m not sure if I understood this correctly, but you want an Enterprise to be linked to their customers, right?
At the database level, you can do this in 2 ways:
In the Enterprise table, add a field called Customers, and make this a list of Customer tables (if the Customers are a few hundred)
or
In the Customer table, add a field called Enterprise, and this is not a list, but a single entry. This way, when you want the Customers for an Enterprise, you can get this by using the Do a search for action on the Customers table where the Enterprise is the one you wish to check for.
Thank you.
When a company makes a profile they will create their ID for customers to use so they will always use that company for service. For example, If a service provider has a customer you want requesting service from you when they request for it it’ll only search for you.
You answered my next question.