Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer Service forum / How to create a multi ...
Customer Service forum

How to create a multi select lookup values + repeated

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi, 

I need to create a solution for a small clinic. they want to offer to patients a set of treatments. 

so for example I have an entity called Treatments which stores all of the treatment types and price for each treatment. 

Now I want to create a form which the provider can select a client, and add the desired treatments.

Each treatment has its specific date, and a specific treatment can be added several times. 

How can I managed to do that using Dynamics 365? 

At first I thought to use N:N relationship and add a subgrid, but in this way I can't add the same lookup value more than once. 

Thanks in advance.

Categories:
Activities
  • Suggested answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: How to create a multi select lookup values + repeated

    Yes, as the new entity is the manual intersect entity, you can have multiple record with the same id's i.e. Treatment1 - Client 1, Treatment2 - Client2 etc.

    Have you created the entity and a lookup on that entity for Treatment & Client. Once you do that you need to create separate records.

    Hope this helps.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to create a multi select lookup values + repeated

    Thanks for replying! 

    will I be able to add a repeating items using this scenario? 

    When I tried to do that it will only allow me to add the same lookup item once

  • Verified answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: How to create a multi select lookup values + repeated

    Hi,

    You can achiev this by creating a new entity say "ClientTreatment" which would be 1:N from Client i.e. i client can have multiple ClientTreatment records. IN this entity, create the lookup to Treatment entity, treatment date & description.

    This should meet your requirement.

    Hope this helps

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans