importing between two tables in the same file

[The Big Bear]

Hi all

I have a file named "BOM_ITEMS" and in the file is two tables. One name "Bom_items" and the other is named "Temp_Bom".

We often get request for duplicate jobs. We fabricated gas compressors. The file is for us to created our Bill of Material.

Once a Bill of Material is completed and a duplicate needs to be made, I imported the BOM to the temp_Bom with no problem and change the Job number to the duplcate job number. The problem is importing the record back to the BOM_Items table.

When naming the file path only the file name is shown and not the table names. I tried typing in the table name but when the import part of the script is actived a message appears stating that Temp_bom cannot be found.

I know I can use the set field command and a looping script but I was wondering if there is a way of importing back in forth between two tables in the same file.

Thanks

Lionel

Edited December 5, 2007 by Guest

[IdealData]

When you IMPORT you must be on a layout that is designed for the TARGET table.

You cannot do the import both ways on the same layout as a layout can only specify one table occurrence for it's data.

[The Big Bear]

Ideadata

I am changing the layouts with I import.

When I import from the BOM_item table I am on the Temp_BOM layout and when i want to import to the BOM_item table , I am on the Bom_Item layout.

The import works from the Bom_item to the Temp_Bom

but not from the Temp_Bom to the BOM_item table.

Thanks

Lionel

[comment]

The Import Records[] script step has two options: 'Specify data source' and 'Specify import order'. The selection of source and target tables and field mapping will become available after you click the button for the second option.

[The Big Bear]

Michael

Thanks for pointing that out to me. I never notice that before. Thanks again

lionel