table unique key and validation

(1) Share

Report

Posted on by Community Member Microsoft Employee

Hello

I have an issue on selecting a record from a table to insert it on anathor i explaine

in the stadrad evrything works i open a table on service line a select a record from table service labor every think is ok.

but on the table service labor i need to put de No. not unique need a key like (make code,No.) and use a filter make code from service header and apply it on service labor.

but my problem on selecting the record from service labor i have a blocking message "the value on field no. cant be found on table service labor.

when i use debug mode i am blocked on form named service order subform validate line

Type::Labor:
BEGIN
Labor.RESET;
Labor.SETCURRENTKEY("Make Code");
Labor.SETFILTER("Make Code",'%1|''''',"Make Code");
IF LookUpMgt.LookUpLabor(Labor,"No.") THEN
VALIDATE("No.",Labor."No.");
END;

*This post is locked for comments

All responses (1)

Answers (0)

Jalmaraz 667 on at

Like (0)

Report

RE: table unique key and validation

The tablerelation of field No. may have a where condition that the selected Labor record doesn´t match.