Re: How do you transfer data from one table to another
- From: Matt Wills <Im@xxxxxxxx>
- Date: Fri, 25 Aug 2006 13:02:21 GMT
In article <1156493727.251619.54840@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
"easyplantmaintenance.com" <lidia.lopinto@xxxxxxxxx> wrote:
I am developing a new application for FileMaker 8 to be served on the
server. I converted an
old FileMaker 6 application and enhanced it. In the old application I
was manipulating
data by doing exports and imports using scripts. Now the data tables
are inside the same file.
In FileMaker 8, is there a way to easily transfer records from one
table into another table
using one command?
From the destination table, you should be able to Import Records, choosethe same file, choose the source table, then do whatever import mapping
is necessary. That can all be scripted.
I tried importing from the same file into the same file adn point to
another table, but that may present a problem with the server software.
I wanted to avoid it, since you need an absolute path for the source
and that could be a problem when moving the file.
I had to use several tricks, like creating look up fields and cutting
and pasting the key field into the new table, etc. It usually involves
a burdensome script with looping, it's all very time consuming.
Any other suggestions?
I don't know why importing from one table to another wouldn't work. You
could always export tab-separated text from one table then reimport.
Comments I have seen in this vein suggest that many developers would ask
why you have to move things around in the first place. As long as you
have fields on which you can do finds and as long as you can define
self-relationships using multiple criteria (using portals as necessary),
why go to all that trouble?
Matt
.
- References:
- How do you transfer data from one table to another
- From: easyplantmaintenance.com
- How do you transfer data from one table to another
- Prev by Date: Re: Using portals with multiple users
- Next by Date: Re: User defined field labels
- Previous by thread: How do you transfer data from one table to another
- Next by thread: Re: How do you transfer data from one table to another
- Index(es):
Relevant Pages
|
