Hi,
We have learnt the hard way, so I thought I would share this.
To avoid challenges down the line it is very important to have the following fields on every form you create. In due time you will have wished you had added these from the start.
-
A - Unique record identifier is best practice in any database, so add an autogen field and a prefix helps when searching
-
B & C - To start recording who created what record from day one. Set the default values and make them read only.
-
D & E - As above start from day one recording who updated records. Set the default values and make them read only.
Add these fields later means you may have lost some history.
Take care