I have a table called lotContents that has two fields in it; mrn(primaryKey) and partNum both are a short-text datatype. I have created a form called workOrderCreationForm that has a text box that auto-generates a work order number. Then the two other text-boxes on the form are called firstMrn...