Can one select more than one option for a field

kolaboykolaboy Member Posts: 446
I am trying to create a field in the employee table which will have more then one options to choose from.

Can i be able to choose more than one option for this particular field. That is if the field say choose and the options are one, two, three, four, five and six.
can i be able to choose say three and four for the field Choose in navision?
Thanks.

Comments

  • ara3nara3n Member Posts: 9,256
    No you can't.

    Option fields are used mainly for business logic reason. So that you are codifying the fields. For example Costing Method.

    For your request. You should a separate table and allow the user to select multiple values. For example Item Unit of Measure.

    So built the tables and relationship between the tables and and allow the user to lookup and select the multiple values.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • WaldoWaldo Member Posts: 3,412
    Indeed.
    You could base your solution on similar solutions in the default NAV application. I'm thinking of stuff in CRM like:
    - Contacts can belong to more than one "business relation"
    - Contacts can belong to more than one "Mailing Group"
    - ...
    Just open the segmentation tab on the Contact Card.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
Sign In or Register to comment.