Support 805.461.7300
Sales
Our Technology. Your Success.
Tech Notes

Add a sequence number to your database

  1. From the Edit menu, choose Fields.
  2. Click on the top field name in the list, then, click Insert.
  3. A Newfield will appear. Highlight the Newfield name and type the word: Record.
  4. Make this field a Numeric type field and make the width of it wide enough to accommodate the amount of records in your database. If your database has 5,000 records then your field should be at least 4 characters wide.
  5. Click OK, then click Yes when prompted to make the Structure changes permanent.
  6. From the Edit menu, choose Command.
  7. Click the New button.
  8. In the Save As box, type, "Add a Record Name" and then press Tab.
  9. In the Command Statement Syntax box type the following command:
    Replace all record with recno()
  10. Click Run.

« Back to Tech Notes

I have been working in pretty much all areas of senior-level IT and Data Processing for many years and have had countless hours of experience engaging with customer support. I’ve never had better support than what I receive from Accuzip! Seriously, any time I call, email, or go to the online chat, someone responds in less than a minute, is always very patient and pleasant, and resolves my issue quickly. Aside from just fixing the problem, your support team always takes the time to explain what the problem was and how to prevent it. It is very refreshing and encouraging to see that real support still exists. Thanks to the Accuzip Team!  I look forward to many more years of engagement with your Team.
M.M., Scottsdale, AZ