Vendor no. and vendor name in new table

vyanku

Hi,
I create a new table having two fields
1) vendor no. and 2)Vendor name.
But when I insert vendor no.(by table relation property) vendor name is not shows automatically.
What i have to do to get the vendor name automatically when I insert vendor no.

Navsyst2

you can use flowfield for field Vendorname or put code into No. onValidate If Vendor.get("Vendor No.") THEN Name := Vendor.Name

DenSter

If you go with a flowfield, put CALCFIELD("Vendor Name") in the Vendor number validation, so you see the name right when you enter a number.

vyanku

Thanks,
But I tried this and it suscessfully run
Flowfield
Lookup("Vendor".name WHERE (No.=FIELD(Vendor no.)))