Final answer:
To use fields from different tables in a crosstab query, establish a relationship through a join. The correctness of a table is based on the data model and desired analysis. Grouping data can be done in various ways, each with its own advantages.
Step-by-step explanation:
When creating a crosstab query, if the fields you want to use for grouping are in different tables, you must first establish a relationship between those tables. This is typically done by defining a join, which is a way to associate rows in one table with rows in another table by using common values, often involving primary and foreign keys. Once the tables are joined correctly, you can proceed to use the fields for grouping in your crosstab query.
Regarding the tables, one is not more correct than the other inherently; it depends on the data model and the relationships established between the tables. The way you group data can differ based on the objective of your analysis. For example, one grouping might provide a high-level summary, while another might offer a detailed breakdown. Each approach to grouping data has its own advantages, which can lend better insights depending on the question you're trying to answer.