is there a way to automatically join tables that already have relationship values?
Welcome! Can you give us more information on what you’re trying to do?
Hi @Kristen
For example, I have 3 tables, users(native), customers, and contracts.
My user table has the person’s full name and so does the customers table.
As well, the customer table has a field called internal ID (unique) and my contracts table has that same internal ID.
Maybe I’m thinking/doing this wrong, but I thought I’m supposed to join them together in order to create these relationships, so later I can restrict views.
My end goal, it to have users to only see data that has them assigned to it based on a field in their user profile.
Also just consider - do you actually need User and Customer? Are they different? If not you might be able to save a step and make the User table the Customer table.
Totally depends on how you’re using the tables.