FieldRef.RELATION fnction in Navision

(0) Share

Report

Posted on by Bheem Singh

HI All,

I have a requirement to check the Relation details at run time. But The FieldRef.RELATION only returns the table No but not the field details of related field.

Any idea how to get the field details also.

eg. The city field in customer table has a able relation in post code table with City field. The relation function returns only 225 not the fields details.
RelationTableID := ToFldRef.RELATION;

Thanks in advance.

Regards

Bheem

*This post is locked for comments

All responses (6)

Answers (1)

Suggested answer

Mohana Yadav 60,232 Super User 2025 Season 1 on at

Like (0)

Report

RE: FieldRef.RELATION fnction in Navision

I always prefer to use Standard NAV functions because they are properly tested and working fine in all scenarios.
mmv 11,469 on at

Like (0)

Report

RE: FieldRef.RELATION fnction in Navision

Hi,

Did the above solution work for you? Please verify the solution.

Best Regards,

MMV
Bheem Singh on at

Like (0)

Report

RE: FieldRef.RELATION fnction in Navision

Hi Mohana and MMV,

Thanks.

I am checking this and I hope I will work.

Also, found one another way to check into Field virtual table directly which contains all these details.

Regards

Bheem
mmv 11,469 on at

Like (0)

Report

RE: FieldRef.RELATION fnction in Navision

hi,

As mentioned by Mohana, you will be able to get the related Table Number and also the Field Number.

Best Regards,

MMV
mmv 11,469 on at

Like (0)

Report

RE: FieldRef.RELATION fnction in Navision

hi,

Please mention what all the field details you are expecting.

Best Regards,

MMV
Verified answer

Mohana Yadav 60,232 Super User 2025 Season 1 on at

Like (0)

Report

RE: FieldRef.RELATION fnction in Navision

Not sure exact requirement

Check Function "GetRelationInfoByIDs" in Codeunit 8617 - Config. Validate Management