Relationship question

[obsoletedude]

Lets assume I have 4 tables and each table has a relationship. What I need to do is remove the relationships, and hopefully place all the tables into one table (for export reasons).

So, as an example, lets say my tables are Customer, Order, Employee, and Shipper. The Customer table has a relationship to the Order Table (say CustID) and the Order table has a relationship to the Employee table (say EmpID) and the Shipper table has a relationship to the Order table (say ProdID).

How can I have all the information from each table placed into one table without compromising the data?

Thanks

 

[RV]

What you need is a query.
Include all tables and required columns in your table.
In your query, join all tables as per the relationships you defined on your tables.
Export the query to a txt or csv file.

RV