Hello - Just finished watching the last lesson in the seminar.  What a course!!  SO much info here.  I appreciate the approach for a service industry.  Really helpful for what I'm attempting to do.

I do have a design question if you are still around.  This topic is quite old.

I'm having trouble wrapping my mind around handling disconnecting a property (location) from one customer (owner) and assigning it to a new customer/owner.  I want to make it pretty straight forward and easy to do but difficult enough (or protected enough) so it cant be done by accident.

We are a property maintenance company in a military town and properties change hand quite often.  So I want to maintain the history of the property even if it changes hands.
Additionally, probably 90-95% of our clients are single family residences. The rest are "commercial" where there might be multiple locations for the same customer.  We don't have any that are multi-unit so that should help simplify a bit.

Any suggestions or comments on changing the design a bit to handle the above situations would be greatly appreciated!

Thanks  - Scott

---

Reply from Alex Hedley:

You will need another Table Ownership History.
When you assign an Owner add a record to this Table, only needs CustomerID and LocationID, DateStart, DateEnd.
When you assign again, update the End of the last record and Start of New.
Now you can query this to see who had it.