I have a database of all my wine. Just a simple one, where I can add/delete/update the information.
As I'm expanding the wine rack, I would like to keep track of where it is, so it is easy to find, when being used.
I have attached a small example of what I'm trying to achieve.
The example table have three different wines, 8 of each, and the location where each bottle is stored.
If Form2 is opened, is shows with the red dots all wine stored, which is in the list.
If Form1 is opened, it shows also all wine, but here Wine2 is highlighted in a different colour, so I can see where in the rack it is.
Question is, how do I get Form2 to show all wine from the list, and leave the rest of the red dots invisible, in order to see free space available?
And how how do I get Form1 to show all bottles, and highlight those I have searched for (this could be through a button, which shows location of the wine selected in e.g. a combo).
Thanks.
Anders
As I'm expanding the wine rack, I would like to keep track of where it is, so it is easy to find, when being used.
I have attached a small example of what I'm trying to achieve.
The example table have three different wines, 8 of each, and the location where each bottle is stored.
If Form2 is opened, is shows with the red dots all wine stored, which is in the list.
If Form1 is opened, it shows also all wine, but here Wine2 is highlighted in a different colour, so I can see where in the rack it is.
Question is, how do I get Form2 to show all wine from the list, and leave the rest of the red dots invisible, in order to see free space available?
And how how do I get Form1 to show all bottles, and highlight those I have searched for (this could be through a button, which shows location of the wine selected in e.g. a combo).
Thanks.
Anders