Archiving Records for Historical Tracking

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lawdawg - 05 Apr 2006 18:29 GMT

I have been task with writing an Inventory Tracking program for my group and
ran into a small problem. I have two numbers used in issuance of inventory
(1) and item number (2) a serial number both of these are set for no
duplicates so the same item is not issued twice. One number is set for one
office as they need an item number to track issued items and the another
office uses a serial number as they do the purchasing. My question is, how
can I create a history tracking file to track turn in items and re-issue
items with the same item number and serial number. I also have a date issue
and a date return fields in the data base. I have had a very basic
introduction to Access Class and this was not covered. Thank you for your
time in advance for any assistance you can provide with this issue.

Reply to this Message

pietlinden@hotmail.com - 05 Apr 2006 21:08 GMT

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.

Reply to this Message

Lawdawg - 06 Apr 2006 11:48 GMT

Thanks for your time and the information, I will look closer in the mentioned
items.

>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.

Reply to this Message