Option 1. Add columns to the Select.
If the order table is directly related to the table via foreign key, then you could include some customer information along with the order number in the lookup field.
That would allow your users to search for orders by number, customer name or anything else you included.
Option 2. Two stage save.
As an alternative you could make the save a two stage process.
- The first stage would save it to the table but with a status of
- To move forward the user would then need to change the
status from "DRAFT" to something else. That could be done via an
ActionButton or some other action.
Depending on your needs this might become a Wizard. See: Data Entry Wizard