If we use Autonumber on two different tables but on the same fields, let's say Sales Table and Cost Table, will it generate the numbers in a way that customers and companies on both table match with the same key number?
I mean if the function generate some numbers independently, it won't work the way that we want to.
Autonumber('foo','Sales Table') and Autonumber('foo','Cost Table')
can (not always) return different values
"
If they could return different outputs for the same input, then the rows will not be matched and our calculations won't return the correct result. Is that right?
You see, we have a couple of complex keys on some huge tables, I was wondering if using autonumber to replace those keys could be beneficial in terms of memory usage. what's your suggestion?
>>If they could return different outputs for the same input, then the rows will not be matched and our calculations won't return the correct result. Is that right? Depends what you name "correct", that function will return same values if you need, and maybe different ones if you don´t need.
I suggest you using autonumber and their similars autonumberhash()
