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, 200718 yr by Guest

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.

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

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.

Michael

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

lionel