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