Newbies bclasen Posted February 22, 2006 Newbies Posted February 22, 2006 Hi, I am relatively new to FMP - I've some experience in other databases (Foxpro & Access). I'm taking over a database that had a field added (recno) that was never used. I want to begin relating other tables to the master - but I need to fill in the recno field with a unique ID (recno) would be fine). Is there a scipt to auto load this table one time? Once done the field is setup to add the next sequential number, but we need to fill in a couple of thousand records first. Any help is appreciated! Bob
LaRetta Posted February 22, 2006 Posted February 22, 2006 Place your cursor in the serial field and select from menu - Records > Replace Field Contents by Serial Number. Check the box 'Update serial in Auto-Entry' and be sure to Show All Records first (and back up first also).
Newbies bclasen Posted February 22, 2006 Author Newbies Posted February 22, 2006 Thanks LaRetta! Worked perfectly!
Recommended Posts
This topic is 6868 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