NetTalk Central

Author Topic: Drop List get another field from the table  (Read 4051 times)

broche

  • Sr. Member
  • ****
  • Posts: 336
    • View Profile
    • Email
Drop List get another field from the table
« on: June 20, 2017, 09:58:20 AM »
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.
Brian

peterH

  • Sr. Member
  • ****
  • Posts: 413
    • View Profile
Re: Drop List get another field from the table
« Reply #1 on: June 20, 2017, 11:21:29 PM »
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

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Drop List get another field from the table
« Reply #2 on: June 21, 2017, 04:26:59 AM »
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