Finance | Project Operations, Human Resources, ...

How to show the fields of a table in a vertical column and have a Value column beside it?

(1) Share

Report

Posted on by Yue Zhen

147

I have a question on Dynamics 365 FnO. I have a table which has some columns. For example, my table named Student, has a few fields such as First Name, Last Name, Age, and Identification Number.

In the form, I will need to display the table fields in the following way:

Fields	Value
First Name
Last Name
Age
Identification Number

The value column should allow users to input value. Each value input will be updated to its respective field. For example, if I enter Elain for the First Name row, the value /Elain/ will be saved to the Student table in the database.

May I know some hints that I can refer to achieve it?

I appreciate any guidance and assistance provided.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Anthony Blake 2,963 Super User 2025 Season 2 on at

Like (0)

Report

What have you tried so far?

Create the table

Create the form

Add the table as the data source

Drop the fields onto the form

Create new questions for issues.

Here's a good guide if you need to start from scratch:

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/user-interface/build-customer-form

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

Like (0)

Report

You'll see an example in almost any form in F&O.

The key concept is that a form has a datasource (your Student table) and the form controls are bound to fields of the data source.

For example, look at CustPaymMode form (Accounts receivable > Payments setup > Methods of payment). Notice that it has a single data source: CustPaymModeTable. Then open properties of a form control showing a field value, e.g. GridOverview_PaymentType. You'll see that's Data Source property is CustPaymModeTable and Data Field is PaymentType. This tells the that is should get the value from PaymentType and save a new value there.

You normally don't have to set these properties manually. You can simply drag a field (or a field group) from a data source to the design.

(Moved from Dynamics AX forum.)

Was this reply helpful? Yes No
Suggested answer

Deepak Agarwal 8,602 on at

Like (0)

Report

Add these fields in a field group (at table level only) and on form design add the group. Of course you wont get it in a tabular form but it will be as coloums.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to show the fields of a table in a vertical column and have a Value column beside it?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to show the fields of a table in a vertical column and have a Value column beside it?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates