Create my own form "Simple list and details" from my own table

Finance and Operations/AX Developer Forum
1

Hi all,

Thanks for reading my question !

I create my own form with type “Simple list and details” and use data source is my own create table

But i have problem : I don’t know how to view a list of records and a details form at the same time. The detail section of the form shows additional fields for the highlighted record in the list.

Do you give me suggestion how to do its,

This is my own form :

5700.4.PNG
5700.4.PNG1331×562 16.7 KB

This is my own table

7571.5.PNG

2

The problem is that your Details section isn’t designed correctly. Throw away the grid and replace it with tabs, groups and controls for individual fields. This is how it should look like:

Please read the guidelines to learn more: Simple List and Details User Experience Guidelines [AX 2012].

You would use a grid in Details section only if you had an additional datasource with more records related to a single IncomeStatement record.

3

Hi Martin Dráb !

For detail i use table "IncomeStatement" and for left grid i use another table call “Header_IncomeStatement”.

Table “IncomeStatement” had JoinSource with “Header_IncomeStatement”.

5808.6.PNG

2742.7.PNG

Anh how to make Relations of “IncomeStatement” and “Header_IncomeStatement” that show view a list of records and a details form at the same time. The detail section of the form shows additional fields for the highlighted record in the list.

4

That’s completely new information. You should have told us all of thatr from the beginning.

First of all, if you set LinkType to Passive, you have to execute the query by yourself. Because you didn’t mention anything that requires a passive link, I assume it’s a bug. Use the Delayed link instead.

Also make sure that both grids are set to their corresponding datasources and that you have a relation from IncomeStatement table to Header_IncomeStatement table.

5

Thanks Martin Dráb !

I set both grids are set to their corresponding datasources, LinkType to Delayed and relation from IncomeStatement table to Header_IncomeStatement table but its not show what i want

6560.9.PNG

1830.10.PNG

5367.11.PNG

6

You don’t see what you want, because the relation makes no sense.

According to you relation, you would see a single line that, by coincidence, got the same record ID as the header. It’s likely that there is no such a line, or it’s completely unrelated to the header.

What you want is creating a new field in IncomeStatement holding values of primary key of Header_IncomeStatement (which may be RecId). Then you have to fill the field with data.

7

Thanks very much Martin !

Now i can create its.

8

0218.2.PNG
0218.2.PNG331×746 9.18 KB
Hi Martin,

I have one more problem with my form.

Now, i want disable “Deducted” if “Credit Account” and “Debit Account” is fill.

And if row only have “Credit Account” or “Debit Account”, “Deducted” will be enable.

Can you give me instruction how to do that ?

Thanks very much !

9

The thread is already closed (meaning that it’s already got a verified answer) and your new question is about a different topic, therefore it doesn’t belong here. Please create a new thread for your new question, with appropriate title and tags.