I need to create a table where say 50 stands are listed.
On the "home" page of the database I want to put a map where the stands are shown (unfortunately the stands are not all square, so breaking them up in seperate pics will be quite tricky.)
Now:
Each stand needs to change to a different colour pic when it is available, reserved or sold. The practical would thus be 3 pics for each site. Eg. one with a green, one yellow and one red button on the picture. When changing the status, the relevant picture would then show. This different colour ics I should figure out. My problem is how to "map" this info so that each stands pic shows that specific stands info on the map. Thus a map with relevant numbers where the different status pictures need to appear. Hope I make myself clear!
Obviously, when clicking the site, the details page will show up, showing info on price, size and a photo or two.
How do I create such a map showing each stands picture on the map? Any suggestions appreciated.