I have an order table with a child order details table. The inital value of the [Order Status] is “Open”. Later the order status is changed to “Exported to Xero”. The order is reopened and nother column in the schema is then changed to indicate that the order has been paid by card or cash etc.
At this point the [Order Status] is then changed back to “Open” for some reason as thought he initial value has been triggered because the order has been opened. I assume the initial value is only implemented in first time the row is created. Is that right? I can’t work out why it is reverting to “Open”.