News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Query is not letting m...

Finance | Project Operations, Human Resources, ...

Unanswered

Query is not letting me make relationship between tables

(0) Share

Report

Report

Posted on by Shabir Ahmad

3,024

Dear Experts,

As i tried to make the relationship between two tables it not letting me make the relationship, please check the images even i click new Relation but in vain.

Thanks and Regards,

Shabir Ahmad

All responses Img

All responses (3)

Answers Img

Answers (0)

Bala Chandra 355 on at

Like (1)

Report

RE: Query is not letting me make relationship between tables

HI,

You can join VendPackingSlipJour directly to PurchLine table.
Shabir Ahmad 3,024 on at

Like (0)

Report

RE: Query is not letting me make relationship between tables

Bala Chandra,

Thanks for your response, now i want to know that in inventdim table and vendpackingslipjour table there is no such a field which have corresponding data what about that?? For example if i want to make relationship between this two table??

Thanks and Regards,

Shabir Ahmad
Bala Chandra 355 on at

Like (1)

Report

RE: Query is not letting me make relationship between tables

Hi,

Check the Relations property on VendPackingSlipJour datasource. It should be changed to No.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans