Multiple Coded Values per Record

[SimonTrinder1]

I would like the ability to choose multiple values from a Domain and assign to a field. ie. Apples, pear, Oranges

Field name =  Contents
Domain Name  =  Fruit
Coded Values =Apples(A), Orange (O), Pears(P), Strawberry(S).

I would like to be ableto choose one or a combination of the values Apples or Apples & Oranges or Apples & Oranges & Pears etc.

So instead of a drop down, when editing the field, there is a check list where I could choose mutiple values.

[TikaAdhikari]

I want multiselect option in the database. For example, example under the fruit attributes, I would like to include all fruits I eat every day. Same as in your example, money/payment is the attribute, I would like to pay with credit card and debit card with for 100 bill. 

[TikaAdhikari]

It is not and it is entirely different and it is not hosted feature service.

[KoryKramer]

Thank you for the response.  So from a coded value domain, you would like to be able to select multiple, correct?

And you're not working with a hosted feature service.  You're working in a geodatabase, correct?

[TikaAdhikari]

Yes, it is not for hosted feature service to be clarify in a much better way. 

[TikaAdhikari]

The issue is enterprise or file geodatabase if I have to separate the domain of the problem. But it has other applications value 

[Bud]

Interesting idea. The underlying data could be stored in a related table (1:M). But the multiple values could be chosen and displayed in the main attribute table/field. That would be easier to view & edit when compared with navigating to a related table.

Alternatively, the multiple values could be stored in an XML column, which would be queryable via SQL in enterprise geodatabases (not sure about mobile geodatabases).

There are probably other ways to do it, such as a comma-delimited field, as mentioned in a comment above. The values could be automatically sorted in alphabetical order upon entry.

Related: Automatically select related records

[KimberlyWinter]

Can we allow mutliple domain values in one field i.e. often we have in forestry multiple different species in one subcompartment. It is impossible to add all of these different combinations as part of a domain but we require data standardisation. 

If you could choose SS / LP/ MB with 'SS' 'LP' and 'MB' all as separate domain values it would ensure the data is standardised without having to add every combination within the domain. 

[HollyTorpey_LSA]

I don't know if it would make sense in your workflow, but you might want to consider using a Survey123 form as your data entry mechanism. Survey123 forms allow multi-select questions and then store the response as comma separated values in a single field.

[troyf_PTC]

And following along with @HollyTorpey_LSA's point, you can build similar functionality within Forms via @Woodpecker 's solution in this idea page Multiple choice option in Field Maps - Esri Community

I have tested it and it seems to work fairly well in trying to convert some of my Survey123 surveys into Smart Forms (in some cases the clearing values might take a minute or so to recalculate to blank with the way I had set it up).