Within our database each ‘user’ or account is assigned to a particular ‘band’ as we’re a musical organisation. That said from time to time people can elect to change from one band to another with conditions;
- Band A must ‘sign off’ releasing the user, this is referred to as ‘Clearance’
- There is a grace period of 14 days, treated like a cooling off period in which they are not eligible
- Band B must accept the person
- At the conclusion of the grace period the record is updated to reflect the users band as being band B and that they are an eligible member again.
For the life of me I can’t think of a way to replicate this process in Knack, further a history of these transfers is needed to be recorded. Ideally we’d like a way for a person to initiate this process themselves.
Any advice would be greatly appreciated.