Finance | Project Operations, Human Resources, ...

dialog form with no datasource

(2) Share

Report

Posted on by ..

1,965

Hi,

If i have a form of type dialog and no datasource

with radio button linked to an enum with 2 options

and another free text string control (not bound to a datasource) that gets enabled when a certain radio button is chosen

now i want this free text string control, when enabled to be lookup of a certain field in a certain table

how to do that?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Martin Dráb 237,844 Most Valuable Professional on at

Like (1)

Report

If the EDT has a reference to a table, a lookup gets created automatically. If it doesn't or you want a different lookup, override lookup() method and implement a lookup there.

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report

Hi Martin,

1. When you say have a reference to a table, do you mean this?

2. it currently has no references, but even if it had, it will return all values in the table, so if i want to return based on a certain Id, i would still need to override lookup method, correct?

I mean if the table is purchLine
PurchId MyField

--

1 x1

1 x2

1 x3

2 xA

then the lookup will return all of those 4 values, but if i want it to return based on the PurchId I'm on, then i will still need to override lookup, correct?

3. In general, when we create EDTs, when do we have to fill table references node? and when we shouldn't? what's the benefit?

Was this reply helpful? Yes No
Minh.Nguyen 19 on at

Like (0)

Report

Hi,

Just would like to help clarify the EDTs and table reference to have the auto lookup. Hope this help!

1/ When creating the EDT (for example the string as below), we may add the Reference table into it as below).

Then you can add the Table References using the Related field.

2/ From the Table, use this EDT with the field. Then you will have the auto lookup from this EDT to this custom table.

Was this reply helpful? Yes No
Martin Dráb 237,844 Most Valuable Professional on at

Like (0)

Report

1. Yes

2. It'll return records according to the relation. It typically means all records, but there may be a filter on the relation.

If you want something else than what's defined by the relation, you want to override lookup() and implement your own lookup logic.

3. Typically, if the EDT represents a primary ID of a table, it's beneficial to define a reference. It'll help with discoverability, the creation of table relations and lookups of unbound controls.

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report

Hi Martin,

So adding a table reference, is just like creating a relation with the table, but in this case no need to create relation, it's taken from EDT?

also not sure what you mean by discoverability?

And when you said filter on relation, you meant the enum filter right?

Was this reply helpful? Yes No
Martin Dráb 237,844 Most Valuable Professional on at

Like (0)

Report

If you use the EDT in a table field, you should still create a table relation. In some cases, the relation gets created automatically when you drag the EDT to to the table (based on the reference on EDT).

When you look at an EDT, you may discover that it's actually related to a table, which one and how. That's useful information in many cases.

If you actually try to create a filter, you'll see that you can use other fields than just enums. But I'm not aware of any EDT that uses something else than an enum.

Was this reply helpful? Yes No