Transfer field valve to text file and increment

[Studiotyphoon]

HI,

I have two tables which currently have Autonumber fields which are
used to create a unique number to identify an invoice for each table.

Instead of having two unique numbers I'm after only one.

My thinking behind this is to

Create a text file with a number in it.
Import the text file into a field and then increment the number and
write it back to the txt file, so it can be called again for the next
invoice, whether it is in the first table or second table.
Incrementing by one everytime it is used.

Is the Transfertext code the write code to consider.

Any advise greatly appreciated

[JohnH]

Re: Transfer field valve to text file and increment

On May 20, 11:20 am, Studiotyphoon <a...@pidesign. co.ukwrote:

HI,
>
I have two tables which currently have Autonumber fields which are
used to create a unique number to identify an invoice for each table.
>
Instead of having two unique numbers I'm after only one.
>
My thinking behind this is to
>
Create a text file with a number in it.
Import the text file into a field and then increment the number and
write it back to the txt file, so it can be called again for the next
invoice, whether it is in the first table or second table.
Incrementing by one everytime it is used.
>
Is the Transfertext code the write code to consider.
>
Any advise greatly appreciated

I don't understand why you're doing what you're doing, but why don't
you just write whatever value you're trying to increment to a field in
a table?