I have two Tables.Table #1 (ProductMaster): has two field, 1.)
Product_Code 2.)DescriptionTable #2 (JobMaster): has two fields,
1.)Product_Code 2.)Job_CodeMy form has two fields: 1.)txtJobCode 2.)
DescriptionWhat 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 th...