I have a database linking volunteers to the tasks that they have volunteered for. Volunteer info is stored in one table and details of jobs in a second. I have an association table containing the VolunteerID with the appropriate JobID. I want to create a form which shows all the jobs available with those that a chosen volunteer has signed up for to be indicated e.g. by highlighting or tick box. How do I do this?
Any help would be welcome. N.B my ability with Access is limited!