AnsweredAssumed Answered

Combining Records into Filemaker

Question asked by KeshNair on Apr 27, 2010

Title

Combining Records into Filemaker

Post

Hi,

Using Filemaker 9. I am new to filemaker.  

We have a process where we imports files from another company into filemaker and then we use this data to make records for order acknowledgement and order shipment.

We get a .csv file to import into filemaker, currently we get one .csv file with four records of the same order number.

Each records has an order number has normal credentials like name address etc... and it has Product details like sequence ID field, product field, quantity field

If I import a .csv file that has four records with the same order number and credentials but different Product details. How can I combine these 4 records into one record showing the same order number and credentials with four product details.

I have already made fields in each record showing 4 product details (Sequence ID 1, Product1, Sequence ID2, Product2....etc)


So when imports i get 4 Records

Record1:

Name:Jon
Adresses: 67 horn st....

Sequence ID: 35089
Product: Cartridge 5
Qty:6


Record2:

Name:Jon
Adresses: 67 horn st....

Sequence ID: 5556556
Product: Cartridge 1
Qty:4

Record 3

Name:Jon
Adresses: 67 horn st....

Sequence ID: 11002
Product: Cartridge 6
Qty:12

Record 4
Name:Jon
Adresses: 67 horn st....

Sequence ID: 0200
Product: Cartridge 56
Qty:20


What I want to do is have one record like this.

Name:Jon
Adresses: 67 horn st....

Sequence ID1: 35089
Product1: Cartridge 5
Qty1:6

Sequence ID2: 5556556
Product2: Cartridge 1
Qty2:4

Sequence ID3: 11002
Product3: Cartridge 6
Qty3:12

Sequence ID4: 0200
Product4: Cartridge 56
Qty4:20

I already have Sequence ID field, Product field and Qty field from 1-4 in each record, I just need help in combing the records/data into one record when I import it.

Any help would be greatly appreciated.

Many Thanks

Kesh








































Outcomes