Data not linking

JacoAucamp — Wed, 15 Mar 2023 12:56:42 GMT

Can someone please assist me, the data in my tables do not link. I have to a fieldname that is in more than one table, but some of the data in the fieldname links to the different tables, but some won't. I assume it has something to do with the data structures, but I am not sure.

As seen in the picture the data looks the same, but it sits in different sides of the column which makes me believe it is has to do with the data structures.

Re: Data not linking

Or — Wed, 15 Mar 2023 12:57:46 GMT

One of these is numeric, and the other is text. You need to convert one or the other (or both, if you want to be safe) so they have the same type, using text() or num#().

topic Data not linking in App Development

Data not linking

Re: Data not linking