I have a table that generates a new autonumber for each new record. I need to use that number in other queries, etc, but in those queries (and odbc connections) it's a Number field and when I try to join it to the autonumber field, it's a type mismatch (no surprise). I want to create a second field in that same table that has the value of the autonumber field and keeps it up to date for all new records (auto refresh after update or something) with the type of Number to be matched to other tables, etc.
What's the best way to do this? Can this be setup as the Default Value of the field in the table to be something like =Value("[autonumberField]") ?
What's the best way to do this? Can this be setup as the Default Value of the field in the table to be something like =Value("[autonumberField]") ?