Good morning to all of you,
I just joined the forum, I'm trying to learn how to use this program myself. I've created a Database, and also a Form. So far I don't seem to understand quite well the Queries.
Well my point... Right now I have 4 Tables, One with the information of an airplanes fleet and the other tables have information on specific components installed in the airplanes, I wanna "filter" in one report, the information of all the components for one specific airplane. I have set "matricula" as the primary key for the main table and "aeronave" as the foreign key for the rest of the tables, so they are related.
I would like to make a report as shown in the following image. Is it possible?

Thanks in advance.
I just joined the forum, I'm trying to learn how to use this program myself. I've created a Database, and also a Form. So far I don't seem to understand quite well the Queries.
Well my point... Right now I have 4 Tables, One with the information of an airplanes fleet and the other tables have information on specific components installed in the airplanes, I wanna "filter" in one report, the information of all the components for one specific airplane. I have set "matricula" as the primary key for the main table and "aeronave" as the foreign key for the rest of the tables, so they are related.
I would like to make a report as shown in the following image. Is it possible?

Thanks in advance.