User would like the InvNbr to be autogenerated in there table.
The field Invoice# is currently text.
So, I've created a new field in a copy of the structure of the PayRcvdTable .....InvNbr
I was able to get it started at the correct number in the new copy of a blank table.
However, How do I get the data from the current table into this new table without having the autonbr fld (InvNbr) generate a nbr for the appended records that shouldn't be populated.
I want any future records in the table to be autogenerated from the starting point I have of InvNbr 80.
The field Invoice# is currently text.
So, I've created a new field in a copy of the structure of the PayRcvdTable .....InvNbr
I was able to get it started at the correct number in the new copy of a blank table.
However, How do I get the data from the current table into this new table without having the autonbr fld (InvNbr) generate a nbr for the appended records that shouldn't be populated.
I want any future records in the table to be autogenerated from the starting point I have of InvNbr 80.