Avoiding Data corruption
|This is what we wish to achieve once we have split the DB|
Example maybe using a form to auto fill Name of the day on a field.
Good example would be the field 'Amount to pay', which is obtained by using multiplying 'Quantity' and 'Price'.
Example: If you have a field 'Employee name' looking up on 'Employee' table for values.If Jon has left the company and you remove his name from the Employee table the field now references some value that does not live in the table anymore. Thus again leads to Corruption. Lookup's in FE is the best way to use. The Tables that you use should only contain data that are being entered. This way you can be rest assured that data can never be corrupted.
Please carry on reading to find ways to Recover your Corrupted file.