Transfer Data to Master Database
This is my file:
I want to do this:
1. Enter data everyday in this file. Basically, data entry is made only in Invoice Table and its portal of Line Table. Every other table gets data directly or indirectly from the Invoice Table.
2. At the end of the day transfer data to another file.
3. Delete data from the file in which I enter data everyday.
4. While deleting data, retain records in specific tables like "Customer", "Product", "CustomerProductJoin" so that the data contained in them is available to me in the drop-down lists and look-ups. (This probably means that I only need to delete the records contained in Invoice and Line Table tables)
Kindly guide me.