Question Track locations on a grid

[dynamite9585]

i havn't gotten too far into this project so any suggestions are possible.

I am writing a database to track our (and others) wine collections.
i'm wanting to track what bottle is where. so i can look up what i have, look up where i have put it and away i go to get it, simple right?

just to complicate things i want a system in place. where the end user and use forms to add/remove or modify wine racks.

assuming that all racks are rectangular i would like to be able to add a rack and call it rack 1. rack 1 has 4 shelves all able to hold 5 bottles. the database would then say that bottle X is in rack 1 shelf 1 position 1.


if possible there will aslo be a screen that is auto generated by the database showing a simple grid with grrn and red squares denoting if the position if full or empty. the ability to click on a position to see what is in there or to add a bottle there would be amasing but not fussed if that can't be done.

Hope i have put enough info in for you to be able to help.

Thanks

 

[dynamite9585]

have solved this problem by getting rid of it.
it over complicates more basic functions. for instance if i have 2 identical bottles (some times i can have up to 12 of the same bottle) each one would need its own record. making the simple process of taking a bottle out of the system more complicated than it needs to be, happy to hear of suggestions if it's still do-able.

but at this stage i am going for each bottle have a Qty field and just naming the rack that it is on

 

[gemma-the-husky]

the problem of "duplicate" values of the "same thing" is tricky

This is exactly the same problem as video lending libraries. given they have 100 copies of the same movie, they need a way of distinguishing between multiple copies of the same movie

so maybe one way is a code for the basic bottle, followed by a counter to identify the "actual item"


so yuo get

item 123456, bottle 1
item 123456, bottlle 2
etc