Design new table using certain fields from linked table on another network

[Alice]

I want to design/automate a new table using certain fields
(with different types of data)from several different
tables located on another network.

Example design of

New table:

Certain Fields:

Type Project Document# Total Oblg Future Yr1 Future Yr2

01 TW200312 125 $170,000 $170,000 $200,000


Tables where different fields are located

PV Buget Table - only displays Future Yr1, Future Yr 2

Appl Table - only displays Type and Project

Doc Table - only displays document


I know I can run a query but I'm trying to develop a new
table. Please help!!

 

[Adrian Jansen]

You can, but why ?

Copying data from one table(s) to another just guarantees that the second
table goes out of date as soon as someone modifies data in the original
table.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[Alice]

Urgent, Can you explain how???? The data is frozen(2003)it
will never change.

 

[Adrian Jansen]

OK, in the rare case where the data will *never* change, then I guess you
can import all the data into another table, but I still dont see the point.
If a query can get the data from where it is now, what do you gain by moving
it to somewhere else, other than using up disk space ?

But if you really have a need to, then just create a table with the fields
you want, and turn a Select query into an Append query to get the data you
want into the new table.


--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control