3 files into 1 files...

[Questions King]

Hi all,

I have three diffent sales, Van Sale/Whole Sales and Retail Sales. Now I need to create the report by three sales together, I was think the only way to go is import, it's?

So, I create the file name(all sales report)this file is for my import all of the three files together. The problem is how I every month the update the report file? and I still need to keep the old record together? At the import option I need to Add new or Update Exiting?

Hope you all undestand my question, and thank for you'll to reply me! :

Sales_Report.zip

[DukeS]

You need to set import options to update matching records ( based on record ID ) and add new records. With this options existing records will be updated and new will be added.

I you leave only add records, every time you will import records all records will be added to the database ( you end up with duplicates ).

[Questions King]

Hi, can you use my files to correct for me? I still not 100% understand what you told me, I was try to use the import option but still fail. For one layout is no problem if I import two or three layout then got problem. Maybe my script has some error, can you fit for me?

Hope you help me and thank for reply!!!

Edited November 8, 2006 by Guest

[DukeS]

Here you go. Notice that before every update there is a script step show all records. It must be becouse importing and exporting is based on actual found sets.

SalesReportMOD.zip

[Questions King]

Excellent! Thank DukeS!