Reference is always a text type???? I created...

references
(M. Engel) #1

Reference is always a text type??? I created a dereference to another table. It’s supposed to look up a number which is unique, but as a label provide the name of a person connected to that number. Then, when the sync is done, there is supposed to be that number again in a spreadsheet column. But that number is placed as a text (it has a ’ before it). When I change this to number the spreadsheet functions correctly, so I must be ‘nearly there’. But I don’t understand, really, why the ‘Referenced Type’ must be a text (especially not, because I am starting out from a number field). What am I doing wrong?

The number has to be in mutliple rows afterwards, because I am trying to ‘build’ a roster for that person.