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)

Sort by

Suggested answer

Anthony Blake 3,158 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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 239,857 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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 9,090 on at

Like
a
(0)

Report
Copy link

Link copied!

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