I am working on a form/subform. The form has a field called Sales Order which is simply a five digit number. The subform has a field call Job Number. Ninety percent of the time, these two fields are the same. Is there an easy way to have the value of the Sales Order automatically copy to the Job Number record on the subform?
Occaisionally, I need to add a suffix letter to the Job Number when a project has multiple phases so I will need the ability to override this process for certain circumstances.
Thanks for the help,
Greg