Hello, very amateur Access user here.
I have 4 large freezers that I store a defined number of boxes in, and I need to create a map for them. Each freezer has a different configuration but all follow the same format of a number of shelves, each shelf has a number of racks, each rack has a number of drawers and each drawer stores a number of boxes. I would like to map these in a 2D grid and then be able to double-click on a box to bring up a list of the box contents. I also need to be able to change the box's location easily (eg cutting and pasting) and delete a box and it's contents.
How can I do this?
A cross-tab report displays the boxes well but it is not interactive
Thanks in advance