Report - Use GET function on no-primary key field

wyper33

Hello everybody,

I'm just started development in Navision and I have a problem using the GET function to show data.
I would like to retrieve a value in table [Vendor Ledger Entry] joined with table [VAT Entry]. Unfortunately, column [Entry No_] is the primary key and I can't use it to join my table. I would like to use [Document No_] but like it's not define as primary key, I got an error message :

"The expresion Code cannot be type-converted to a Option Value"

After some research, nobody has been able to give an answer to my problem. Can you help me please ?

Thanks in advance.

Sog

That's because the GET function only works with primary keys.
So to answer your question "Use Get function on no-primary key field". It is not possible, and never will be possible.

Maybe you should look into filters, the find(set/first/last) functions and the C/Side introduction course. F1 can help too