scriptitng an import

June 23, 200520 yr

Hi gang,

I have a solution that has a Job table, a job line item table, a quote table and a quote line item table. Originally I did not have the quotes separated but had a status field that showed open or quote. My users couldn't be trusted to use them properly (don't ask), so I am separating them.

The problem I have is that when a quote (that has already been entered into the Quote and Quote Line item table)is approved, I want to create a job record for it. It was simple enough creating a Job record with all the info. the line items are giving me trouble. I can do a loop setting each field separately but with some of these jobs with hundreds of line items, it can slow down considerably. I wanted to do an import, but can't seem to get it to only import the found set. I looked into copy all records but don't know how to paste into more than one field. Any suggestions would be greatly appreciated. It is driving me nuts.

June 23, 200520 yr

I ran across a similar situation except I needed to import more than 1 Rep for each order. If you visit the attached thread my last post has a link to my soultion for "auto-entering" more than one record.

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=164087&an=0&page=0#164087

June 23, 200520 yr

Author

thanks for your reply,

how do you import just a found set when all your tables are in the same file?

June 24, 200520 yr

Michael asked ... how do you import just a found set when all your tables are in the same file?

Importing between tables is no different than importing between multiple files. Your layouts (which specify your table occurrences) are the key.

Perform your find to isolate the records you wish to import FROM. Switch to a layout based upon a table you wish to import INTO. Select Import File and select the same file name (yeah seems wonky but you'll get used to it).

When your import dialog opens be sure your Source (top left pop-up) points to the table occurrence of the layout holding your found set.