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 linking field but cannot seem to find a way. Any guidance on this? I am happy to work off a replica mirror table if that is something can be created off the connected table or if there are any QB actions created but need help.