Relationship With A connected Table

I have a connected QB table in an app. This has record ID as the key field. It has a field known as location number. I am quite keen to relate this table to another table using location number as the ...