Drop List get another field from the table

[broche]

NT 9....
CL10

Using drop list on a field to get the Supervisor ID from another table.  Want to fill in a couple more fields on the form from drop selection. Where do I do this please?

Brian.

[peterH]

Hi Brian,

In the ValidateValue routine of your lookup field you can read the selected record (or any other file or record for that matter) and get additional fields. Remember to assign to session values.

Peter

[Bruce]

Peter is right.
Also remember you will need to open the "other table" and read the record here to "load" the other values.

cheers
Bruce