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
This makes sense.
The equipment ID field in Table A was a text field - which is why the number displayed correctly.
However, the equipment ID field in Table B must be a numeric field because we use the equipment ID in a summary field with a numeric function ("minimum").
We create variations of this summary field to bring multiple records from Table B into a single record in Table C.
For example:
Summary field 1: minimum equipment record ID
Summary field 2: minimum equipment record ID that is greater than summary field 1
Summary field 3: minimum equipment record ID that is greater than summary field 2
Summary field 4: minimum equipment record ID that is greater than summary field 3
etc. up to 100 . . .
The summary field becomes the reference field in 100 relationships between Table B and Table C.
This allows us to bring data from up to 100 records in Table B into a single record in Table C. Data must be in a single record in Table C so it can be exported to a digital form (for use in the field).
Is there another way to bring data from many records into a single record? Or a function we could use on a text-type field to achieve the same result?
13 digits is unfortunately not enough digits for the information we need to track. What do you mean by "without rounding"? Does that allow for decimal places?
The equipment ID field in Table A was a text field - which is why the number displayed correctly.
However, the equipment ID field in Table B must be a numeric field because we use the equipment ID in a summary field with a numeric function ("minimum").
We create variations of this summary field to bring multiple records from Table B into a single record in Table C.
For example:
Summary field 1: minimum equipment record ID
Summary field 2: minimum equipment record ID that is greater than summary field 1
Summary field 3: minimum equipment record ID that is greater than summary field 2
Summary field 4: minimum equipment record ID that is greater than summary field 3
etc. up to 100 . . .
The summary field becomes the reference field in 100 relationships between Table B and Table C.
This allows us to bring data from up to 100 records in Table B into a single record in Table C. Data must be in a single record in Table C so it can be exported to a digital form (for use in the field).
Is there another way to bring data from many records into a single record? Or a function we could use on a text-type field to achieve the same result?
13 digits is unfortunately not enough digits for the information we need to track. What do you mean by "without rounding"? Does that allow for decimal places?