Your setup seems un-normalized (e.g. you will have to add a field if another situation needs to be covered - a sure sign). Maybe you have a spreadsheet type design throughout instead of being normalized.
Methinks you ought to have a field "Status" with values such as Hold, Complete, Quote. That would mean that a new additional value would not require an additional field. A date field for complete might also be of some value, as it not only denotes the order is complete (when not null) but also provides the when. However, you would not usually use 2 fields to provide the same status information. Maybe check out
Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.com...ng-part-i.html
and/or
http://holowczak.com/database-normalization/
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.