Relationship With A connected Table

Question

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.&nbsp;

quickbasecoachd · Answer

Is the Location # unique in that table?&nbsp; ie are there any duplicates or could there be any duplicates?&nbsp; If not, then you may change the Key field of the connected table to be the Location.

arshadkhwaja · Answer

Thanks. &nbsp;Yes it is unique. This is an easy option and thank you for the insight.&nbsp;

quickbasecoachd · Answer

You should ensure that on the source table, that Location field is marked as unique.

Forum Discussion

Relationship With A connected Table

3 Replies

Related Content

Help connecting Table to Table Relationships

Filter records based on table connection

Cross App Relationships

Table Relationships - Connected CSV Table

How to Link Tables in a Complex Many-to-Many Relationship?