Access Junctions - An Overview
B. If it demands a Junction table, is there a method to semi-automate the population of that desk? As an example, an update or append query that will scan the Teacher & Programs tables and populate the Junction desk with the classes they are able to educate.See this updated example. The primary instance utilizes just the junction desk for a records