triplell89
Registered User.
- Local time
- Today, 07:53
- Joined
- May 21, 2009
- Messages
- 21
So I have a table, and I want to add some information from it to the bottom of another table. I'm using the append function, and I want one of the fields to be incremented for the additional rows. IE, my current table ends at 12000, and I want to append 147 rows to this table. For the first record I append, I want the ID to be 12001, and the second 12002, and so on.
I tried using an expression that took the max value of the field, and then add 1 to it, however it just does it for every field (all 147 fields assigned the value 12001). Next I tried to have that expression increment itself, and I got a circular reference error.
I was hoping someone could help me figure this out.
Appreciated
I tried using an expression that took the max value of the field, and then add 1 to it, however it just does it for every field (all 147 fields assigned the value 12001). Next I tried to have that expression increment itself, and I got a circular reference error.
I was hoping someone could help me figure this out.
Appreciated