Split out Import Data

I have a file that contains a customer record (serial number 000000) and a
number of addresses associated with that customer (serial numbers >000000).

I need to find the customer record (000000) and move the name into a
customer name field, the address into customer address, city/state and zip
into customer city/stateand zip (ONLY for that "000000" record) delete the
customer record 000000 leaving only the associated addresses left in the
file (serial number >000000) which were imported into name, address,
city/state and zip (different fields than above). The customer fields are
global.

The file is imported into the FM database and I will add a button to execute
the above.

Would this be best accomplished in a script, calculation or validation and
how could I accomplish this?

FileMaker Pro v9, Windows.

Seems simple, but I can't get it to cooperate.

Thanks in advance!

PghOPS wrote:

> I have a file that contains a customer record (serial number 000000) and a
> number of addresses associated with that customer (serial numbers >000000).

best would be to give a short sample of input and ouput tables...

> Would this be best accomplished in a script, calculation or validation and
> how could I accomplish this?

calculation is a good tool for debugging, but takes too much ressources
and fields cannot be use as indexes.
once your formulas are validated, the choice between scrpit and
validation depends of other features of your DB...

May be you can have other import procedures with other calcs in the
future ? then a script is better. If not, validation is good enough.

Split out Import Data

Split out Import Data

Re: Split out Import Data