help please ???????

[BenjaminTheBlue]

I am new to Access and i am trying to create a database to log media cartridges in and out. Just found out my wife is pregnant so i really need this to get my bonus ......

I have most of it set up, but need a way to log carts out and keep a record of them.

When i log them in, i have a field that gives it autonumber() . This allocates a slot to store in the racks.Then i have a query that comes up with all the carts due back for today.

My problem is,that when the query comes up, i cannot overwrite the "autonumber slot number" or clear it. I was going have in the procedure, to give the slot number a zero to say it has gone back to the owner, but this seems a bit naff. At least then i could have another query to bring up the history by criteria 0 for slot numbers. Anyone give me any ideas to think of a way to log carts out, so as the slot number would become available again for other carts being logged in.
i thought of having a location field on the main form to say home or offsite, but i cannot overwrite the slot or delete it.

Many Thanks for any help at all
Ben

 

[stopher]

I think you'd need to give more detail about your table structure. However, clearly the autonumber is your problem and makes your solution far more difficult than necessary.

I would expect to see a table that lists all your media. In this table there would be a field (not autonumber) where you can enter a slot number. Then there's no problem erasing the slot number when the cart is logged out.

You could have other tables e.g. one for the list of slots (although the relationship to carts is 1-1). Obviously you may have other tables e.g. a logged-out table etc.

Stopher