>1) How do I copy selected fields from one table to a newly created
KT>table? I want to do this so that I may split my original table into
KT>three tables.
This I understand. The quick easy simple way. Make 3 copies of the
table each with a new name. Then restructure each deleting the fields
you don't want. Be sure and keep a common field for linking in queries.
Or do a query selecting all the fields for the first table you want in
the new table plus a common field. rename answer table (in pdoxwin
direct anser to a certain name) Repeat for 2nd and 3rd table.
Patrick West
Owner/Operator
PC Care
"Your High Tech Janitor"
Portland,Or. U.S.A.
e-mail: patrick.west@nwcs.org
---
* POW 1.1 On Trial * Error Backup not found: (A)bort (R)etry (P)C CARE
--- WILDMAIL!/WC v4.12
---------------
* Origin: NWCS Online (1:105/362.0)
|