LindaG Posted April 22, 2004 Share Posted April 22, 2004 I have a group of records that I imported. And I messed up. and it's too late to use the backup and do it again because I no longer have the file which contains the import records. I imported invoices from another program into our new FM invoicing system. Boss wanted to capture the data. They ended up being one field off partway through the map. Me bad. Records 73069 through 73995 (the end of the db) need to be shifted one field over. I can script this shift, but I need to isolate only these records from the rest of the database. How can I find by record number? Should I create a field called RecordNumber and use Status(CurrentRecordNumber)?? Or should I find the RecordID? There is nothing else that I can use to isolate these records ... I just know they are at the bottom (end) of the file. Please help me! Boss needs report and it'll be wrong! Linda FileMaker Version: 6 Platform: Windows XP Link to comment Share on other sites More sharing options...
Ender Posted April 22, 2004 Share Posted April 22, 2004 Create a new number field, renumber it with your record order intact, then locate the starting serial number that is giving you trouble. Use that for a find in that field (>=2342 or whatever). To correct these I might suggest you export them, delete the found set, then import them with the correct field mapping. Link to comment Share on other sites More sharing options...
Fitch Posted April 22, 2004 Share Posted April 22, 2004 Just go to the first record and Omit Multiple, 73068. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7308 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now