Record lifecycle: the states a record moves through — Legal moves, and what each state demands

This is the part a plain Select cannot do. For each state you set: • Which states it may move to. A move you haven't allowed is refused when someone tries it, rather than quietly recorded. • Required fields — what must be filled in before a record is allowed to arrive here. • Locked fields — what stops being editable once it does. • Whether a record in this state may be deleted.