Hi Barb, I didn't see this post until after I answered your last one "a table cannot be imported into itself" help!!
It sounds like what you are missing, is understanding that the layout must be based upon the target?
thanks for your feedback...guess the real question is then how do i add the "layout" to the target and source??
these are the steps in the edit scripts:
1. Go to Layout [Column Report (2009-2010)] - specificy: Column Report
2. Perform Find (Restore] ) Action: Find Records Criteria: 2009-2010::Therapist: [="Drop"]
3. Import Records [No dialog; "Drops 2009 10"](specificy data source - did that fine, unless that's where i'm not clicking on the right file, i have a file i'm using for practice before using on the real one); Specify import order: Source: 2009-2010 Target: 2009-2010 2 (i have that because i added a table when i clicked on manage databases. The tech guy thought i should have had a "copy" but in FM 10 that didn't exist, he was working in Advanced.
4. Delete All records (no dialog)
5. Show all records
any help would be greatly appreciated!!
Working in two different threads, each with bits and pieces of different information is making it difficult.
When you find your records, that is the Source. Where do you want to copy them? Is there an existing table to copy them into? You need a layout based upon the target table. Do you have a table in your graph to receive this information? If not, you can actually create a target during your import. When the import dialog appears, you can pop open the target pop-up and at the bottom will be the words 'new table' and it will create a layout based upon this new table and copy your records into it.
But again ... I would really like to understand what you are doing and why. Is this a one-time migration?