GET not working?!

aquinco

Hi guys, I have created two tables:
-Model - which has field "Manufacturer Code" and "Model". "Manufacturer Code" is in relation with "Code" in table Manufacturer. I have set this table to have complex primary key: Manufacturer Code, Model
-Variant - with fields "Manufacturer COde", "Model" and "Variant No.". "Manufacturer Code" is in relation with "Manufacturer Code" in table Model. I have set this table to have complex primary key: Manufacturer Code, Model

I wish for a field "Model" in table Variant to fill automatically when I choose manufacturer from dropdown menu so I wrote this code in

Manufacturer Code - OnValidate()

IF ModelRec.GET ("Manufacturer Code")
THEN BEGIN
Model:=ModelRec."Model No.";

END;

where ModelRec is record variable on table Model.

But it doesn't work and I do not know why since I've done this many times.

RockWithNAV

If Primary key is a combination of two fields then you need to pass both the fields when you are using get statement.

Rec.Get(PK1,PK2,PK3......);

aquinco

THANKS IN ADVANCE!!!!

RockWithNAV

If Primary key is a combination of two fields then you need to pass both the fields when you are using get statement.

Rec.Get(PK1,PK2,PK3......);

archer89

use ModelRec.GET ("Manufacturer Code",Model) instead. your issue could also be done with a flowfield.