|
Home > Archive > MS Access database support > April 2006 > Re: Archiving Records for Historical Tracking
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: Archiving Records for Historical Tracking
|
|
| pietlinden@hotmail.com 2006-04-05, 8:28 pm |
| If an item can be issued and returned multiple times, you can't use
just the itemID or whatever as primary key. You need something like
{itemID, issueDate} or something like that as a compound primary key.
Make friends with the Access Help. There's tons of stuff in there.
also poke through some of the sample databases.
| |
| Lawdawg via AccessMonster.com 2006-04-06, 7:41 am |
| Thanks for your time and the information, I will look closer in the mentioned
items.
pietlinden@hotmail.com wrote:
>If an item can be issued and returned multiple times, you can't use
>just the itemID or whatever as primary key. You need something like
>{itemID, issueDate} or something like that as a compound primary key.
>Make friends with the Access Help. There's tons of stuff in there.
>also poke through some of the sample databases.
--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...access/200604/1
|
|
|
|
|