Report from Multiple Tables

remotesk8

New member
Local time
Today, 16:54
Joined
Jul 11, 2013
Messages
9
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?
Untitled-1.jpg
Thanks in advance.
 
This is the basic queries required. Open a new query window and select SQL view then post one of the following into the window. Return to query builder view so you can see graphically what it looks like. Note you have not provided table names (unless it is Table 1) so please change as required

1. All information for N7532A

SELECT * FROM Table1 WHERE Matricula='N7532A'

2. ELT

SELECT * FROM Table2 WHERE Aeronave='N7532A'

3. ATC

SELECT * FROM Table3 WHERE Aeronave='N7532A'

4. FDR

SELECT * FROM Table4 WHERE Aeronave='N7532A'

5. If you want all information in one report then

SELECT *
FROM ((Table1 INNER JOIN Table2 ON Table1.Matricula = Table2.Aeronave) INNER JOIN Table3 ON Table1.Matricula = Table3.Aeronave) INNER JOIN Table4 ON Table1.Matricula = Table4.Aeronave
 
Hello CJ_London,

Thanks for the quick reply. I've tried the solution you gave, nonetheless, what I get for the
report is way to largo (width), see attached Untitled2.png. Is there anyway I can get every information I want one below the other as the picture I uploaded on my first post? please

Also as you can see right now, all the information is shown twice I don't know why. Thanks again.
 
Ah - understand.

Assuming you are doing a report, you need to create 4 reports, one for each of 1-4. The create a new unbound report (no recordsouce) and drag each of the 4 previously created reports onto it and place where required
 
OMG! Thankssssss finally I got what I wanted!! Awesome, thank you so much! Now I'm working on the report details. I do have another question. Will all the information be updated automatically in the report? for example if I were to change a P/N or S/N in one of the tables? Thankss!
 
It should do providing the report is either opened or requeried after the change.

Note: Changes to a field will not take place in the db until the record is updated. The record is normally updated by going to a new or another record (e.g. another line in a datasheet or continuous form or the next or previous record in a single form) or by closing the form. Alternatively you may have a button to save the record
 
OMG! Thankssssss finally I got what I wanted!! Awesome, thank you so much! Now I'm working on the report details. I do have another question. Will all the information be updated automatically in the report? for example if I were to change a P/N or S/N in one of the tables? Thankss!
 

Users who are viewing this thread

Back
Top Bottom