C/CAL fields from another table

DappreStrijder
DappreStrijder Member Posts: 8
in NAV/Navision Classic Client
Hi,

Can something explain to me how to add a field from another table in C/CAL code using NAV2009.
I want to add a field from another table on a usage excel export function.

Thanks for answer.

Answers

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    identify the common key fields between both tables.
    find the record with those fields and get the value of required field.

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • DappreStrijder
    DappreStrijder Member Posts: 8
    I understand. For example:

    EnterCell(RowNo,1,'Ord.line status',TRUE,FALSE); ##From the header

    This will export the right status.
    Now i want on the other line for example 2 another record from another table.


    EnterCell(RowNo,2,'Order.number',TRUE,FALSE); ## From the line

    This will not work because the unknown variable. How do i fix or how do i set the relation.

Categories