Avatar of ITsolutionWizard
ITsolutionWizard
Flag for United States of America asked on

dynamics crm

I use account and contact as a container to store like

insurance company
consumer name
contractor name

has account entity have any field to indicate what type of accounts it is? for example. on the web form I want to create a drop down with look up to insurance company only and I don't know how to do that ?
Microsoft Dynamics

Avatar of undefined
Last Comment
Feridun Kadir

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Feridun Kadir

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ITsolutionWizard

ASKER
I will have many account type
like insurance company, consumer, vendor and contactor

but on the web form like drop down with look up option. how can I select e.g. insurance company ?
Feridun Kadir

OK, you want to have multiple values. So do you want to have a picklist, where the user selects the relevant value?

There is an out of the box field called Industry which you can use. You can customize the values to suit your needs.

Or you can create your own new field and select type option set. If you are using Dynamics Online version 9.0 or later you can create a multi-select option set that allows you to select multiple values.

You say "drop down with look up option".  I wonder do you mean a lookup to another record type, select a parent account for a contact?  That is a a completely different process and requires creating a custom entity.
ITsolutionWizard

ASKER
I like to use account entity and have account type field makes sense to me.

now when I have for example lead form and I add custom field called insurance company and the data source is entity look up to account entity. is it possible to look up account type = insurance company? so I can get list of insurance company
when the lead form is opened?
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ITsolutionWizard

ASKER
option set is not my choice because I need it to be updated by our user
ITsolutionWizard

ASKER
any helps?
Feridun Kadir

OK, I think I understand what you want a bit better now. I think you need a filtered lookup. Add a lookup field to account to the lead form.  Create a view for account that filters for accounts where account type = insurance company as a system view. Then in the lookup field on the lead form, you can choose the "insurance company " view and also choose not to allow the user to change the view.

Is that closer to what you are asking?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ITsolutionWizard

ASKER
very closed ....
just hope if I can have some thing I can follow the steps
Feridun Kadir

Sure, I'll post something later today.
Feridun Kadir

Sorry I've been busy with some work assignments. DO you still need help with this?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck