I have a Table that with a random type of AutoNumbers and it contained the following fields. The OrderNo field is not unique and it can be duplicated.
OrderNo Category Year JOBNo
SDQ-001-04 SDQ 2004 40132345
SCQ-123-03 SCQ 2003 40152344
(1). I want a situation where whenever the OrderNo is completed the Category, and Year are automatically filled as shown above. The Order number field itself Must be defaulted to:
_ _ _ - _ _ _ - _ _ in such a way that it loks like: SDQ-001-04
(i). The JobNo begins with 401_____. Is there a way to have default to 401 in such a way that if the other numbers are entered, the whole field MUST be updated into the tablOrderDetails like 40132345.
(ii). If there is NO JOBNo, then I dont want the 401 inserted into the JOBNo field in the tableOrderDetails.
Suggestions are welcomed.