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

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

Not sure exact requirement

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

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

hi,

Please mention what all the field details you are expecting.

Best Regards,

MMV

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

hi,

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

Best Regards,

MMV

Was this reply helpful? Yes No
Bheem Singh on at

Like (0)

Report

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

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

Hi,

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

Best Regards,

MMV

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

I always prefer to use Standard NAV functions because they are properly tested and working fine in all scenarios.

Was this reply helpful? Yes No