Hi,
I would like some advise on how to make my database. Actually is already done and working for months now, but I have a problem and I don't know how to solve it.
Currently, the basic structure is like this:
I have a client, each client have a product. T1 is Truck 1, Truck 2. Each Truck has 1 or more drivers (D1, D2).
Every year I need to update the product, meaning the Truck will change. So I will exclude (hide) the T1 and input a new one, T3 for example. The problem is that the drivers won't change. So, if I put a new one, I need to input all drivers again, because they are related to T1. But T1 is over, expired. I dont want to modify T1 to T3, because I dont want to lose old information. So instead of replacing T1 to T3, which is actually what is happening, I create a new record, T3. But the Drivers from T1 should come with it.
Any ideas?