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 ...
Is the Location # unique in that table? ie are there any duplicates or could there be any duplicates? If not, then you may change the Key field of the connected table to be the Location.