Search the Community

Our database was created before formulas were allowed in tables. Due to relationships, table restrictions and being live, I would like to fix this without using formulas. I have a submit form that is creating a Work Order Number by concatenating the Equipment_VIN and Time Stamp. In the form the Equipment_VIN is chosen by drop drop down from an equipment table. The form works perfectly. When I change the Equipment_VIN to autocomplete so the VIN numbers are easier to find the element of the VIN is no longer pulled by the script. Anyone have an idea as to why this is happening? Here is the script I am running in the footer. The script points to an HTML block div that is called "won" for work order number. <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var position1 = document.getElementById("InsertRecordEquipment_VIN").value; var position2 = '[@cbTimestamp]'; var allpositions = position1 +" "+ position2; document.getElementById("InsertRecordWork_Order_Number").value = allpositions; document.getElementById("won").innerHTML= "Work Order Number is: " + allpositions; } document.getElementById("Submit").onmouseover=concatenate; </SCRIPT>