Missing fields when I try to add a relationship on a data source

(0) Share

Report

Posted on by AstridMalanka

449

Hello,

I need to add the vendor name to my purchase order line entity.

So I extended the entity and added the vendor table.

I am trying to add the DirPartyTable to get the vendor name, but when I go to do the relationship, the vendtable fields are empty.

I will add pictures

I am not sure why is not letting me add the field to join,

From what understand I need to do: vendtable.party = dirpartytable.recid

thanks

All responses (14)

Answers (2)

AstridMalanka 449 on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

As I needed a field from the table and not the view, this is my final result.
GirishS 27,832 Super User 2024 Season 1 on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

After giving Join relation name you no need to select related field and field from the lookup. It will fetch the relation automatically from vend table.

Thanks,

Girish S.
AstridMalanka 449 on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

i added a name, still empty fields.
AstridMalanka 449 on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

what do you mean? i did the join and I am doing the relationship, where do that?
AstridMalanka 449 on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

Maybe is case sencitive? I need to try that. I just copy the relationship from the vend entity, I am trying that, like copy paste.
AstridMalanka 449 on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

I have the same issue, I add the view, but the field view is empty, and when I try to add it manually it doesnt let me.
GirishS 27,832 Super User 2024 Season 1 on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

After adding DirPartyView as datasource you need to give "Join relation name" property.

Thanks,

Girish S.
Martin Dráb 230,064 Most Valuable Professional on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

Can you please elaborate what you mean by "it doesnt let me"? I did it successfully.
AstridMalanka 449 on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

i tried adding the field manually, but it doesnt let me
AstridMalanka 449 on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

I tried DirPartyView and still the field is empty. I also check the vendor entity and I see it uses DirPartyBaseEntity but it is not letting me choose the field. what is the difference between data source and derived data source?