How to make two tables from one table

G

GL

Hi
I have a database and I would like to modify the structure of a table.
The existing form of the table is:
ResourceCode, ProjectCode, ResourceCost, ResourceDescr, ProjectStartDate,
ProjectEndDate, key on ResourceCode and ProjectCode.
What I would like to have is two tables:
ResourceCode, ResourceCost, ResourceDescr, key on ResourceCode.
and
ProjectCode, fkResourceCode, ProjectStartDate, ProjectEndDate, key on
ProjectCode.
The two tables are joined on ResourceCode and fkResourceCode.
Because I have a lot of data on the first table I want to make the other two
ones and keep the existing data.
Do you know how?

Thank you

GL
 
B

Bob Miller

Create two Make Table queries of the data you want in each table and ru
them. Or, you can copy the original table and delete the unwante
information in each table to reflect your wants.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
Create query with table columns as rows 5
Update field in one table with value from another 4
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Format column widths from one table to a separate table on same page 1
How to have two tables on same line? 1
Question about table relationships 1
Find ALL references to deleted field? 4

Top