Finance | Project Operations, Human Resources, ...

Can I reference a field in table to show in my form

(0) Share

Report

Posted on by Chomchanok

253

Refer to our point I research in my Database and write SQL to see relation in Database

---------------------

select document,PAYMADVICEID,voucher,LASTSETTLEVOUCHER,* from HSTHPaymAdviceLine

left join VENDTRANS on HSTHPaymAdviceLine.document = VENDTRANS.LASTSETTLEVOUCHER

where LASTSETTLEVOUCHER='EIN22000616'

--------------------

After that I saw the output that I want

--------------------

Next I develop my form on D365 by include table in AOT to my project

Then I try to do a grid to represent information that I want but I know in the beginning I need to join a relation to table that I want.

But on this step I got a limitation that I can't do.

And at the end I wish to have an output like this PPVNO show in this area.

Can someone guide me what's wrong is it?

Thanakorn

All responses (5)

Answers (0)

GirishS 27,821 Super User 2024 Season 1 on at

Like (1)

Report

RE: Can I reference a field in table to show in my form

Have you debugged the code?

Try debug the code and check whether you are getting buffer for select statement display method.

Also check whether Document field has a value present in the table and also in VendTrans table.

Thanks,

Girish S.
Chomchanok 253 on at

Like (0)

Report

RE: Can I reference a field in table to show in my form

Dear Girish and all,

Now I change some method to retrived data in to in my grid and I think I go to the right direction but output are not correct. May this is a way that you guide me, can you guide me more details.

1. I create methods in my table.

2. In a method I write a basic thing to refer datat that I want to show.

3.After that I Mapping in my grid.

4. I Build and run, No error happen but data are not show in table.

Anyone can help me?

Thanks in advance,

Thanakorn
Suggested answer

GirishS 27,821 Super User 2024 Season 1 on at

Like (1)

Report

RE: Can I reference a field in table to show in my form

Unfortunately, I cannot find the reference for your issue. My suggestion will be adding a display method for the particular field if the form is only for viewing purpose.

Thanks,

Girish S.
Chomchanok 253 on at

Like (0)

Report

RE: Can I reference a field in table to show in my form

Dear Girish

Can you guide me more details or reference a forum that similar this case pls?

Thanks in advance.

Thanakorn
Suggested answer

GirishS 27,821 Super User 2024 Season 1 on at

Like (1)

Report

RE: Can I reference a field in table to show in my form

Hi Thanakorn Kanjiropas,

Reference DataSource will be added only if foreign key relation between HSTHPaymAdviceLine table and VendTrans table. I don't think there is no relation as such.

So, to resolve this issue you can go for display method for particular field.

Thanks,

Girish S.