Archiving Records for Historical Tracking

[Lawdawg via AccessMonster.com]

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.

--
Message posted via http://www.accessmonster.com

[pietlinden]

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]

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

pi********@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 AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200604/1