Error on starting report

Red-Eagle

My report for the purchase order give the following error:

The expression code cannt excuted a typeconversion to an option value.

The line which is causing this is:

IF relkenmerk.GET("Purchase Header"."Job No.") THEN;

relkenmerk is the table "Contact Feature Type"

i want to connect Contact Feature Type.Code with the purchase header. this fields has to match because i want to use the remarks which is in this table.

What i am doing wrong

mohana_cse06

what is the primary key in Contact Feature Type and field types?

Red-Eagle

The keys are:

Relation Type,Code,Line No.
Relation Type,Code,Feature Group,Feature
Relation Type,Feature Group,Feature,Code

mohana_cse06

Then you cant simply use get

use

relkenmerk.RESET;
relkenmerk.SETRANGE(Code,"Purchase Header"."Job No.");
IF relkenmerk.FINDFIRST THEN;

Red-Eagle

I still get a error. Now it is saying A field of a recordvariable is expected

I don't hope i need to set a jobnr there, want that is every time different.

My code so far, with your advice:


IF "Purchase Header"."Buy-from Vendor No." = 'L1134' THEN BEGIN
relkenmerksoort.RESET;
relkenmerksoort.SETRANGE("Purchase Header"."Job No.");
IF relkenmerksoort.FINDFIRST THEN;
"Purchase Header"."Your Reference" := relkenmerksoort.Remarks;
END;

mohana_cse06

Red-Eagle wrote:

I still get a error. Now it is saying A field of a recordvariable is expected
I don't hope i need to set a jobnr there, want that is every time different.
My code so far, with your advice:

do you have "Job No." field in Purchase Header table?

if yes,
is your code same as what i suggested?

Red-Eagle wrote:

relkenmerksoort.SETRANGE("Purchase Header"."Job No.");

Red-Eagle

Hmm, :oops: I am very sorry. I did make mistake. I did not put "code," in the line.

But your option is working. I thank you very much!

mohana_cse06

Welcome