Table key from table-to-table import error
We create an equipment ID field in Table A. The equipment ID is a formula field that creates a unique number: List("",[ToText: Job ID],[ToText: Sort Order],[ToText: Record ID + 100M],"3") ...
Forum Discussion
My long time understanding is that Quick Base can handle up to 13 digits accurately. My suggestion is to convert to use text numbers as they will always be correct. The Combined text summary fields will solve your roll up issues. That is a new feature on the last few months.
It will be the first 25 unique values. The only sort is alpha.