Tom's Guide | Tom's Hardware | Tom's Games
 |
 |
 |
I am building a database in Access 2007. 2 of
my forms are "Salesman" and "Client". 1
salesman has many clients but 1 client can
only have one salesman. The problem is this:
if the client suddenly decides to go to another
salesman and I change the information in the
Clients table, all previous sales and records of
that client are set to the new salesman. How
can I leave the old information untouched?
(Leave old sales with old salesman's name
and make new ones with a diff salesman)
I hope I explained it clearly. Thank you!
 |
 |
 |
| Login or Register to Reply | |
| Login | Register |
| Ads by Google |
