Hello! I'm not sure if I'm posting this in the right place, so if not--please point me in the right direction.
I'm new to Salesforce, and I'm setting up my org for a law firm. My question/issue relates to how to structure/organize my data. We are an estate planning law firm, so we have clients (who are individuals). The clients are often referred to us by other professional firms (like financial advisory companies) and/or by the individual financial advisors at those companies. What I'm struggling with is how to set up my data.
Here's what I'm thinking: For individual clients I should use the Contact object. For the individual financial advisors, I should also use Contacts? For the financial advisory companies, I use Accounts.
Here's where my issue comes in: I'd like to be able to see/track all of the clients that come from a single advisory firm. My concern is this: if I use "Contacts" for both the individual clients and the individual financial advisors and connect all those contacts to the Advisory Firm Account, I'm worried that all that data will be mixed.
Is there a better way to structure my data? Can I create different contact record types for "clients" and "financial advisors"? Is there a way to separate the types of contacts related to an Account?
To summarize my current plan:
Individual clients = Contact object
Individual financial advisors = Contact object
Financial advisory company = Account object
Do I link both individual clients and individual financial advisors to the same account? Is there a better way to relate this data?
Thanks in advance!
Daniel, i used chatgpt to check its suggested method. Its view is as follows
Setting up your data structure in Salesforce for your estate planning law firm involves organizing your data in a way that reflects the relationships between clients, referring firms, and individual advisors. Here's a suggested approach:
- Object Structure:
- Client Object: Create a custom object named "Client" to store information about your clients. Include fields such as name, contact information, relevant dates (e.g., birthdate, date of initial consultation), and any other relevant details.
- Referring Firm Object: Create another custom object named "Referring Firm" to store information about the professional firms that refer clients to your law firm. Include fields for the firm's name, contact information, and any other relevant details.
- Advisor Object: Create a custom object named "Advisor" to store information about individual financial advisors associated with referring firms. Include fields for the advisor's name, contact information, affiliated firm, and any other relevant details.
- Relationships:
- Client-Referring Firm Relationship: Create a lookup or master-detail relationship between the "Client" and "Referring Firm" objects. This allows you to link clients to the referring firms that referred them to your law firm.
- Advisor-Referring Firm Relationship: Similarly, create a lookup or master-detail relationship between the "Advisor" and "Referring Firm" objects. This allows you to link individual advisors to the referring firms they are associated with.
- Data Entry:
- When adding a new client record, associate the client with the referring firm that referred them to your law firm. You can do this by selecting the appropriate referring firm in a lookup field on the client record.
- Optionally, you can also associate clients with specific advisors within the referring firm if there is a designated advisor who referred the client.
Regards
Ramesh
- Object Structure:
