Jump to content

Changing the owner of a device


danielrmitchell
 Share

This topic is 2899 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 2899 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.