My solution is to assist in maintaining records in my computer repair business.

It has customers, who have devices, which have service records.

 

I sometimes buy devices from customers, or the device may be reallocated to, for example 'recycle' or 'parts'.

 

I would like to be able to reassign the owner (via a dropdown) of a device, maintaining its service records but also keeping a log of previous owners and the dates of reassigning.

 

For example

 

• Customer 1 owns Device 1
• Customer 1 decides to sell Device 1 to my Company on 1/12/14
• Company refurbishes Device 1 and sells it to Customer 2 on 14/12/14

How might I go about implementing this please?

 

PS: Very sorry if this is not clear, please let me know if you require further clarification to assist.

It sounds like you need a 3rd table giving details of ownership, joining devices table to the owners table.

That way a person could have many records, each detailing ownership of different devices, and each device could be owned by more than one person.

You could have bought from / sold to fields that are drop downs from your people table.

 

Hope that helps - it's probably about as far as I can get you - I'm not great at this!!

 

Cheers,

Mike