Relations between Customer Contacts and Job Responsibilities

(0) Share

Report

Posted on by Community Member

Hi,

I am using NAV 2013.

I want to create a Jet report to show all Customer Contacts and Contact Job Responsibilities. But I could find any available link. Can someone explain the tables relations between Customer Contacts and Job Responsibilities?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Alexander Ermakov 28,096 on at

Like (0)

Report

Contact Job Responsibility table (5067) links Contact table (5050) with Job Responsibility (5066).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you!

Was this reply helpful? Yes No
Alexander Ermakov 28,096 on at

Like (0)

Report

This third table is used because the data needs to have many-to-many relationship: one contact might have several job responsibilities and many contacts might have the same job responsibility.

Was this reply helpful? Yes No