Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
duplicating records in pdox7
- Thread starter pumkinjay
- Start date
You mean you want double records of nr 284 in the same table or in a new table?
If the field is not the key, you can do it either way.
If it is, you can only make a new table. This is a simple query operation. Hit file>new>query . Chose the file containing the records and enter your criteria in the fields. For instance > 234. If you aren't sure of the syntax just go to your help files.
This will make a separate table, the answer table in your private folder. (c:\corel\<rest of path to paradox>\private\answer.db).
You can close everything now and import the contents of the answer table to your existing table, with the caveat on the keyed field.
If the field is not the key, you can do it either way.
If it is, you can only make a new table. This is a simple query operation. Hit file>new>query . Chose the file containing the records and enter your criteria in the fields. For instance > 234. If you aren't sure of the syntax just go to your help files.
This will make a separate table, the answer table in your private folder. (c:\corel\<rest of path to paradox>\private\answer.db).
You can close everything now and import the contents of the answer table to your existing table, with the caveat on the keyed field.
- Thread starter
- #3
thanks for you time in replying.
I think me question was not explained very well.
I will try again.
I Have a form and link to it is a table
| No | product | no of containers | Qty | U.O.M |
| 1 | orange | 2 | 25 | kg |
| 2 | bananas | 3 | 50 | kg |
What i want to do is run a push button so that the each record is multiplied by the number in "no of containers"
| No | product | no of containers | Qty | U.O.M |
| 1 | orange | 1 | 25 | kg |
| 1 | orange | 1 | 25 | kg |
| 2 | bananas | 1 | 50 | kg |
| 2 | bananas | 1 | 50 | kg |
| 2 | bananas | 1 | 50 | kg |
cany u help ??
I think me question was not explained very well.
I will try again.
I Have a form and link to it is a table
| No | product | no of containers | Qty | U.O.M |
| 1 | orange | 2 | 25 | kg |
| 2 | bananas | 3 | 50 | kg |
What i want to do is run a push button so that the each record is multiplied by the number in "no of containers"
| No | product | no of containers | Qty | U.O.M |
| 1 | orange | 1 | 25 | kg |
| 1 | orange | 1 | 25 | kg |
| 2 | bananas | 1 | 50 | kg |
| 2 | bananas | 1 | 50 | kg |
| 2 | bananas | 1 | 50 | kg |
cany u help ??
- Status
Similar threads
- Locked
- Question