In a query you equal join MakeID pk (primary key) to MakeID fk (foreign key) and ModelID pk to ModelID fk. You drag the Make, Model and Trim fields into the query. The query returns "Ford" not 2. The report recordsource is that query. You usually don't need the ID fields in the query but it doesn't hurt to have them. If you use the report wizard to create the report they will end up there but would be pretty much useless much of the time. The exception would be when you need to refer to the pk field(s) in order to attain unique references.
Last edited by Micron; 10-03-2023 at 12:31 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.