I’m having trouble working out a way that doesn’t require programming to deal with a set of many to many relationships in Access. I’ve gathered that the best way to achieve this is to have three linked tables, with two one-to-many relationships. So, with a set of names and details in one table, and a set of conditions in the other, I’m linking them by a third table with
Is there a simple way of setting up a form to enter data, either by multiply-selecting from a list, or having a list of checkboxes to tick against?
And how do I set up queries to generate data about numbers, totals, averages, etc?
Many thanks,
Victor
