Join table

[RunForrestRun]

Hi, I have two tables and wants to join them using a view. I have a field in my first table that has a Prefixed Auto number datatype and a field in my second table that has an Auto number data type however, I cannot match these fields. Is there something I am doing wrong?

[Flowers4Algernon]

Hi, despite their names, I believe autonumber data type is incompatible with prefixed autonumber data type. Prexifed autonumber datatype is only compatible with Text(255) and Prefixed autonumber data types. You may  also read this how-to article: https://howto.caspio.com/tables-and-views/relationships/database-relationships/

 

Hope this helps!