Shawn
asked on
contact changes company. where are the orders?
I have a delemma on how to best manage client contacts. We have tblContacts with the name of the person, etc. This also has a CompanyID which is linked to tblComanies.
When a person moves from campany A to company B this creates a little havoc with that persons orders.
I am wondering if there is a best practice for this type of situation.
Any suggestions?
When a person moves from campany A to company B this creates a little havoc with that persons orders.
I am wondering if there is a best practice for this type of situation.
Any suggestions?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok, wrapping my head around it and this should work. I will keep my 1:1 relationship and add your suggested table tblPersonCompany. I can populate this via a temp query and set up contacts to populate the 'old' system and the 'new' system....then slowly, as needed migrate to the new one.
thank you :)
PS would you recommend any sites/books on real life concepts, relations, scenarios similar to this?
thank you :)
PS would you recommend any sites/books on real life concepts, relations, scenarios similar to this?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>>The order itself should have a company id (usu. called a "customer id" or some equivalent) on it that does not depend on the Contact.
agreed. though certain fields in the contact belonging to the company (framework contract IDs) was not automatically changed. There is just a lot of cleanup to do and we need to prevent this from happenning again.
>>... you could just issue them a new ContactID....If you wanted, you could add a separate table with a list / history of anyone issued multiple contact ids.
good idea.thx
agreed. though certain fields in the contact belonging to the company (framework contract IDs) was not automatically changed. There is just a lot of cleanup to do and we need to prevent this from happenning again.
>>... you could just issue them a new ContactID....If you wanted, you could add a separate table with a list / history of anyone issued multiple contact ids.
good idea.thx
FYI, you should never change order history. An order once complete is a permanent record.
If/when you do data mining or other historical analysis, you want the order to be accurate to the time it was done, not adjusted for today's data.
If/when you do data mining or other historical analysis, you want the order to be accurate to the time it was done, not adjusted for today's data.
ASKER
>>FYI, you should never change order history. An order once complete is a permanent record.
Agreed, and this is usually the case. :-)
Agreed, and this is usually the case. :-)
ASKER