Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

I get an error when I try to choose multi option from lookup field.

(0) ShareShare
ReportReport
Posted on by 84

Hi

When I try to choose multi options from lookup fields I get this error.

This field is new, I have added it on this page.

  • Suggested answer
    Lama Khaled Profile Picture
    Lama Khaled 84 on at
    RE: I get an error when I try to choose multi option from lookup field.

    Thank you, Mr. Zhou

    [quote user="ZHU YUN"]

    Hi, It looks like you're using a lookup trigger, so why keep the TableRelation property? I think it would be better to delete this property directly.

    More details: https://yzhums.com/5985/#toc2

    Hope this helps.

    Thanks.

    ZHU

    [/quote]

    0743.png4111.png1731.png3107.png1805.png  

    The link that you have put in this comment contains very useful details.

    I didn't use the methods that you used in the link, I wrote a different code, but I benefited a lot from the idea of ​​using a codeunit.

    Now, I have a new problem when I want to print this multiple choice that has been selected, only one option is print, but if I choose more than one option, it remains empty in the report!!

    What should I do to print all the options selected from the lookup field on the report??

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    RE: I get an error when I try to choose multi option from lookup field.

    Hi, It looks like you're using a lookup trigger, so why keep the TableRelation property? I think it would be better to delete this property directly.

    More details: https://yzhums.com/5985/#toc2

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: I get an error when I try to choose multi option from lookup field.

    You need to change the trigger from OnAssit to OnValidate. and then try again.

  • Lama Khaled Profile Picture
    Lama Khaled 84 on at
    RE: I get an error when I try to choose multi option from lookup field.

    Yes, I added this property but nothing changed.

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,194 Super User 2024 Season 2 on at
    RE: I get an error when I try to choose multi option from lookup field.

    Did you try setting the below property to Special Terms?

    ValidateTableRelation=false;

    But I believe it will allow to enter any text.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans