Using a userform and database to fill multiple fields

Brian Kurtz

• 2020年10月08日 21:06

We are successfully using user forms to look up data from a database. We would like to add to that, with a single input, filling multiple output fields.

 

Ex: At print time, the user is prompted to input a Work order number from the database list. The system then outputs the lot number as a result.

I would like to expand on that functionality with the system to output both a lot number into one field, and a production date into another field, but using a single input(work order). 

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • 2020年10月09日 14:39

  Sorry not sure what you mean:

  Is the Production Date

  • part of the works order number?
  • one of the database fields?
  • or set by the system date ?

   

  0
• 

  Brian Kurtz

  ★ BarTender Hero ★

  • 2020年10月12日 13:28

  The production date is one of the database fields.

  0

請登入寫評論。