Borrow A Table
Structure
Example
If you have a table that is similar (or even identical) to a new table you want to create, its much easier for you to borrow the structure of the existing table, then make any changes you may need, than to create a new table from scratch.
Here is an example of how you can do this.
First open Database Desktop.
Next go to File | New | Table
Click the OK button when the dialog box appears, we will be using the default Paradox 7 for this example.
Now you are able to see the Create Paradox Table dialog box.
At the bottom of the Create Paradox Table dialog box you will see a button called Borrow, please click on this button.
Now you will see the Select Borrow Table dialog box.
You will see a list of tables in the current directory.
Go to the Alias drop down list, click on it and choose DBDemos.
You will see a list of tables that you can borrow from.
Choose one now, try customer.db to start with.
At the bottom of the Select Borrow
Table
dialog box you will see the word Options and to the right of
the
word Options you will see some check boxes.
These are the properties we may want to
borrow from the table we have chosen.
Here we can choose any table properties we want to borrow.
This is a list of the available options:
Primary Index - Click on this to borrow the primary index from the chosen Paradox table. Validity Checks - Click on this to borrow the validity checks from the chosen Paradox table. Lookup Table - Click on this to borrow the lookup table assignments from fields in the chosen Paradox table. Secondary Indexes - Click on this to borrow the secondary indexes from the chosen Paradox table. Referential Integrity - Click on this to borrow the referential integrity relationships from fields in the chosen Paradox table. Note:
The options you can borrow vary according to the type of table you are
going to create.
|
Check any that you want to borrow and then click on the Open button.
You can now see the Create Paradox Table dialog box again.
You can now add data or make changes to the structure of the table as you need and then save your new table.
Copyright © 1998-2002 James M
Sandbrook
& Sandbrook Software. All rights reserved.
Do not duplicate or redistribute in any
form.