TIP: Click on subject to list as thread! ANSI
echo: paradox
to: KEN THOMPSON
from: PATRICK WEST
date: 1995-06-12 21:17:00
subject: Pdox45 moving data to new

>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)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.