Link through 2 tables?

JonA

Hi there.

In standard Navision 5.0 tables and forms I need to add the comments attached to all interaction log entries for each contact as a viewable list in the contact card. The problem I have is that the inter. Log entry comment line table only has a key of the interaction number, not the contact number.
So, basically I somehow need to link the the contact number through to get every interaction log entry for that contact and then filter a sub form of the comments showing every comment record for each interaction that has one that are related to the contact in question.

Does anybody know how I would do this - I'm a beginner with Nav and any tips greatly appreciated.
I'd like to achieve this without code if at all possible.

ara3n

It's not possible without some code.

The easiest way to do this is to add contact No to comment table.

Write a processing report to populate all existing comments with contact no.


Then modify oninsert Trigger of comment table to populate Contact No..