Output Data To Second Table

[TLJ]

out put data from one table to another

I believe this is a simple question. I have a main table and several other tables within a database. They all are keyed with the same primary key and are joined together.

I want each sub table to list the Last Name and First name from the main table as well as the primary key value for each record. I want to be able to export some of the tables occassionally to excel and I want names on the tables with the primary keys instead of the blank columns with last name and first name headings.

Thanks for any assistance.

 

[Pat Hartman]

Storing the same data in multiple tables is not necessary. In a relational database all you need to do is to store the key to the data. Then using a query that joins your tables, you can get any columns you want. You would then use these queries as the recordsources for your forms and reports or to export to Excel. So for example, you would store the CustomerID in the Order table. When you print the order, you use a query that joins the Order table to the Customer table so that you can print data that comes from both tables in the same report.