I have a Form created with many form fields. The fields in question are related to parts that are for sale. I have 3 different columns..."Part Number", "Part Description", and "Price". I would like my document to automatically fill in the description and price based upon my entry in the part number field. I am assuming I need a certain script to make this happen?
The next part of my problem is connecting it to a database. I know how to connect and add the database into the software, but needed about using multiple tables. The "Part Number" and "Part Description" are in one table and the "Price" is in another table. Do I need to have these in there own table, or will this just be reflected in my script or some other way?
Any help is appreciated. I'm very computer literate, but will be honest in saying I know VERY little about javascript.
