ms access training - I woul like to know more about connecting relationship?

Using SQL you can achieve this.

Use a SELECT QUERY to select the data from the different tables and use the UNION command tojoin them together.

So, it looks like this:

SELECT [Table1.field1],[Table1.field2],[Table1.field3],
FROM Table1
UNION
SELECT [Table2.field1],[Table2.field2],[Table3.field3],
FROM Table2

Field 1, 2, and 3 must be the same data type