C/CAL fields from another table

DappreStrijder

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.

mohana_cse06

identify the common key fields between both tables.
find the record with those fields and get the value of required field.

DappreStrijder

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.