Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Table Field with EDT with EDT with lookup FormHelp

(0) ShareShare
ReportReport
Posted on by 15

Hi everyone. I have a table with a field that extend Extended Data Types and this one again extend from another Extended data Type that has a lookup form in FormHelp.

When I open the table and I do clic in this field, it open a form with the single value, when It has a value, and when It hasn't appears empty with a sigle selection option like combobox. But is closes when you clic on it.

Any clue whats wrong?

2450.form.jpg

Thank you for your time.

  • Alain.z Profile Picture
    Alain.z 15 on at
    RE: Table Field with EDT with EDT with lookup FormHelp

    Hi Sergei Minozhenko,

    It works perfect with "this.query().dataSourceTable(tablenum(tablename)).clearDynalinks();".

    Thank you very much.

  • Verified answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,091 on at
    RE: Table Field with EDT with EDT with lookup FormHelp

    Hi Alain.z,

    It could dynalink issue. When the relation is set up between tables or on EDT and you open a form that contains a related table as root data source records in this data source are filtered by value from the related field on the original record.

    You can clear dynalinks by executing clearDynalinks method on query build data source object. In form B you need to expand data sources node and on the root data override method init and execute clearDynalinks method after super call.

    void init()
    {
        super();
    
        this.query().dataSourceName(this.name()).clearDynalinks();
    }

  • Alain.z Profile Picture
    Alain.z 15 on at
    RE: Table Field with EDT with EDT with lookup FormHelp

    Hi Sergei Minozhenko.

    Yes It's a custom form. (I did´nt do it) I'm new about Dynamics. You where right about the properties that were set to yes. It fixes the point of edit capabilities.

    Relations:

    0434.form2.jpg

    The init method from FormHelp form has this code:

      element.selectMode(BTable_field1); Like I said, I'm new in dynamics so I don´t know what it does.

    Thank you for everyting.

  • Suggested answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,091 on at
    RE: Table Field with EDT with EDT with lookup FormHelp

    Hi Alain.z

    Is it a custom form used in FormHelp?

    From the upper part, it seems that AllowCreate\AllowDelete\AllowEdit\InsertAtEnd\InsertIfEmpty properties are not set to No on data source of the lookup form, so form is opened with edit capabilities.

    Do you have any relations between table from where lookup is opened and table used in the formHelp form? Probably relation was not set correctly.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,403 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans