Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6868 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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

Posted

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).

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.