Hi Wise Ones...
I've attached a database and I'm having the following problems with it...
The user wants the following ((View all locations painted
) to have a list of locations down the left and then for the users to just click on a location/month (it'll change colour when done - thanks for the help on that one :-) ) so that they have an overview of the entire painting occurrence.
Then I have set up a form (View History) which should show the individual history for each location - but it's not. E.g. if you click on View History
for Admissions it should show July and January painted (or even ticked) but it's not...what am I missing?