Mr. Rost,

Thanks Alex Hedley btw. This may seem like a silly question but what's the purpose of building individual tables if you can just build a junction table with everything in it? When building a form with all the fields you want displayed, shouldn't you add the fields from the junction table instead of individually from each table to avoid type mismatches? That's why I'm asking about the purpose of building individual tables.

---

Reply from Alex Hedley:

A Junction Table is usually a one that links two tables together using IDs.
You can then use a Query to join these Tables together.
Once you have the Query you can then use that as the source of your Form.
The individual Tables are better to keep your database normalised.