Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by Chomchanok

282

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

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

GirishS 27,833 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Chomchanok 282 on at

Like (0)

Report
Copy link

Link copied!

Dear Girish

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

Thanks in advance.

Thanakorn

Was this reply helpful? Yes No
Suggested answer

GirishS 27,833 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Chomchanok 282 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
GirishS 27,833 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No