Raf Columns no Work When i Change Key Column

[Euzbio]

Hi Guys,

Could you please help me with this qestion.

I have a Stock Table, and i have a Orders table.

Orders table is the main table, and the SKU is the key column. So when i change to Order Number as a Key column, The Reference that i have with Stock SKU and Orders SKU stop to working and a cant see my actual stock fot this SKU.

[Marc_Dillon]

https://help.appsheet.com/en/articles/961426-references-between-tables

[Euzbio]

Hello,

I know what the documentation says, the problem is that the information is crossed only when the Order ID is marked as Key in the order table but it cannot be the Key. How to get around this, selecting another Key column and still managing to cross references with the Order ID column

[Steve]

Correct, that is expected behavior.

What is a key? - AppSheet Help

References between tables - AppSheet Help

[Euzbio]

I Want to change key colun and keep ref showing related data. Bot it dont happen once i change de key column.