Using the primary key as the seed + 10000 to be a string number for another field in each record of a table (1 Viewer)

atrium

Registered User.
Local time
Tomorrow, 08:45
Joined
May 13, 2014
Messages
348
I have a file with about 5000 records I want to set up a new string field on each record. I want to use the records primary key, add 10000 to it and save it.

Any help would be very appreciated
 

plog

Banishment Pending
Local time
Today, 17:45
Joined
May 11, 2011
Messages
11,646
2 Why's:

1. Why do you need this value?

2. Why do you need to save it?

You don't store calculated values, so even if you do need this number you shouldn't store it. You should build a query and reference that query when you need that value.

In a query you would use this to generate your value:

YourNumber: ID + 100000
 

Users who are viewing this thread

Top Bottom