Search results

OK, here goes another question regarding my project. Short intro: the project is about organizing boxes and files in them. Each box has 250 slots, each slot for one file. I'm using Access 2003. In one of my tables each record represents a file stored on a specific position [SlotID] in one of...

Thanks for your reply Trevor. I decided for a VBA approach which works just fine. Thanks anyway!

I have a database of basically two tables - tblBoxes and tblFilesInBox. Each box has got 250 slots to store files. In tblFilesInBox, I keep the records of files that are stored in the boxes, including their position (slot) in the box. If the slot is free, there is no information stored about it...

Thanks Gemma! Now I have these tables and relationships between them. I think it is perfectly what I need. Is there anything from the relationship point of view that could be wrong about it?

Thanks for your reply, Gemma. I think I need to have a table for slots, because what I need to know for any given folder is: - the ID of the box - the # of the slot in this box where the folder is stored. Yeah, I think that wouldn't be a good thing to prepopulate the slot table with empty records.

Hey guys, I'm having kinda trouble deciding about table relationships in a database I am designing. It's about storing physical folders into specific position in boxes. Each box has got say 200 slots. One slot can hold only one folder. The thing is to find the location of a folder based on...