OK, I’m building a database application in Access 2002, and I have 14 tables that I need to JOIN toghether nicely. I have a hard time getting Access to accept my syntax, so I’m probably not doing it right. (The code Access produced itself from the wizard didn’t work either 🙂
Anyway – these tables are generally the “contact” table (leftmost) and the rest are normalized tables with relations to “contact”. They are set up in two levels, first a “cross-reference” table and then a “values” table. The cross-ref contains the contact-id and the value-id only.
Now, finally to the question:
How do I go about JOINing these. Do I start at the first level and join in those first (i.e. all cross-ref tables first, then all value tables), or do I need to go to the bottom with each branch before starting on the next (i.e. first cross-ref, then value-table, next cross-ref, next value-table).
Any pointers would be apreciated – TIA!
peace,
Tormod in Stockholm