Raf Columns no Work When i Change Key Column

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.

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

Correct, that is expected behavior.

What is a key? - AppSheet Help

References between tables - AppSheet Help

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

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