Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Script Help needed for pulling from an SQL table

Avatar

Level 1

I have two Tables.

Table #1 (ProductMaster):  has two field, 1.) Product_Code  2.)Description

Table #2 (JobMaster): has two fields, 1.)Product_Code  2.)Job_Code

My form has two fields: 1.)txtJobCode   2.) Description

What I need to have happen is when the user types a Job number in the txtJobCode field, the Description field is autopopulated with the correct Description from the ProductMaster table.

The link between the two tables is the Product_Code field but how do I write the script statement to say this? 

Thanks,

Randy

0 Replies