Microsoft Dynamics AX (Archived)

how to build form which has multiple datasources?

(0) Share

Report

Posted on by BASMA

932

Hi,

I want to create form which has multiple datasources : "securityUserRole","userInfo" and "securityRole" .

I want to display in form 2 fields : one from securityRole the other from userInfo:

6378.form.png

but I don't how to add relation between it in datasources to get the exact values.

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (2)

nmaenpaa 101,160 Moderator on at

Like (0)

Report

One role can be associated with many users. And vice versa.

How are you planning to represent this information in your two fields? This determines what kind of relations you need.

Do you want to have one row for each role - user combination? For example role A is associated with users 1, 2 and 3 you would have following rows in the grid:

A 1

A 2

A 3

Is this what you want?

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

I want like this :

I want to represent it like your suggestion

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Put following properties on the UserInfo and SecurityRole data sources:

JoinSource: SecurityUserRole

LinkType: InnerJoin

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

I add your suggestion but I don't show values in form.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

For me it works.

What exactly you see now? Do you have any data on the form?

It should show one record for each record in SecurityUserRole table. And show corresponding role name and user name from the other tables.

Could you share screenshots of your data sources' properties?

And obviously your Grid's data source must be set to SecurityUserRole. Otherwise the grid has nothing to show.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

And what is the data source for your grid?

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

I dont set datasource in grid :

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Please do. Then it will work.

You have to link your main data source to the grid. Then the grid will show data from your main data source. And also from the linked data sources. Without data source the grid will show nothing.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

which datasource I set in the grid?

Was this reply helpful? Yes No