This is quite hard to explain, I need to do a clean up of my database for my accountant to view.
In my database there are Customers, Bookings, and Quotations.
For example, Booking 1 is allocated to customer 6, who received quotation number 234.
I want to clean it up so that Booking 1 is allocated to customer 1, who received quotation number 1.
But without losing any of the date
Can it be done?