BenjaminTheBlue
Registered User.
- Local time
- Today, 08:55
- Joined
- Dec 14, 2006
- Messages
- 14
Hello,
Could anyone point me in the right direction of creating a database that would allocate a number 1-800 for cartridges when logging them in and then when logging them out free up that number again, but keep a record of returned cartridges. I have tried autonumber, but dont know how to make autonumber pick at random between 1 and 800.
I also i really need a history of cartridges sent back but with the original allocated number freed for more incoming cartridges.
Does anyone know if this can be done or if i can pay someone to add this little bit to my database? I have amended the book keeping template, but need a way to log carts out and free the autonumber allocated. It all works well and i have a query that gives a list of carts to return by return date, but just deleting them doesnt keep a record history.
Many Thanks For Any Advice Ben
Could anyone point me in the right direction of creating a database that would allocate a number 1-800 for cartridges when logging them in and then when logging them out free up that number again, but keep a record of returned cartridges. I have tried autonumber, but dont know how to make autonumber pick at random between 1 and 800.
I also i really need a history of cartridges sent back but with the original allocated number freed for more incoming cartridges.
Does anyone know if this can be done or if i can pay someone to add this little bit to my database? I have amended the book keeping template, but need a way to log carts out and free the autonumber allocated. It all works well and i have a query that gives a list of carts to return by return date, but just deleting them doesnt keep a record history.
Many Thanks For Any Advice Ben
Last edited:
