Hi all,
I'm seeking some advice on a good way of implementing an order status field for my Shipments table. This field will be displayed under the shipments section of the orders form to quickly show the user what stage of the process the order is currently in. I would like this to be a field in the Shipments table because my intention is to use the status field in queries.
I initially thought the statuses could be determined based on which fields have data entered in the Shipments table. This seems plausible because the fields in this table are populated in a constant sequence as the order progresses, e.g 'Planned' status if the 'Planned Production Date' field has a date, moving onto 'Transport Booked' status when the 'Date Transport Booked' field has a date. In other words, transport wouldn't be booked until there is a planned production date entered. The status field would be controlled by VBA to select the appropriate status title.
However, I feel this system could be easily broken if data is not entered or accidently entered out of sequence, so is there a better way of achieving this or does my idea have potential?
Thank you for your assistance.
Chris
I'm seeking some advice on a good way of implementing an order status field for my Shipments table. This field will be displayed under the shipments section of the orders form to quickly show the user what stage of the process the order is currently in. I would like this to be a field in the Shipments table because my intention is to use the status field in queries.
I initially thought the statuses could be determined based on which fields have data entered in the Shipments table. This seems plausible because the fields in this table are populated in a constant sequence as the order progresses, e.g 'Planned' status if the 'Planned Production Date' field has a date, moving onto 'Transport Booked' status when the 'Date Transport Booked' field has a date. In other words, transport wouldn't be booked until there is a planned production date entered. The status field would be controlled by VBA to select the appropriate status title.
However, I feel this system could be easily broken if data is not entered or accidently entered out of sequence, so is there a better way of achieving this or does my idea have potential?
Thank you for your assistance.
Chris