Select Data > Edit Relationships.
In the Edit Relationships dialog box, do the following:
Select a data source for Primary data source, and select a data source for Secondary data source.
Select Custom.
To define a relationship between fields that have different names, click Add.
To edit an existing relationship, select the fields on the right, and then click Edit.
In the Add/Edit Field Mapping dialog box, do the following, and then click OK:
Under Primary data source field, select a field.
Under Secondary data source field, select a field with similar data to the field you selected for the primary data source.
For more information about editing relationships, see Blend Your Data.
--
Terrance | Apps4Rent
Hello,
I have been able to solve it with a query as indicated.
Thank you
Hello,
It sounds like what you need to use is an Query object. With a Query object, you will be able to join the two or more tables. Then on the CUE table you will need to create a new normal field that gets populated through AL code. In the AL code you will need to at least initialize the value in the page OnOpenPage trigger. I have included some links to our documentation that should help:
• Query Object: docs.microsoft.com/.../devenv-query-object
• Creating CUEs: docs.microsoft.com/.../devenv-cues-action-tiles
• Page Triggers: docs.microsoft.com/.../devenv-page-and-action-triggers
Best Regards,
Thomas Brownell
Sr Support Engineer
Dynamics NAV/Business Central
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156