Hi @anacarolinagr
@Relationships are based on the GUID column, not the primary column. Although in the UI, it may look like it’s the text main column, due to how it’s presented when looking at a UI.
For sample if you had a primary column of Text and you created a relationship. In the other table on the form or looking at that table in the designer you’d see the text of the main column not the guid.
You can also create Connections between tables which are simply relating them based on a Named connection you create. Like pretend you had a table called people. And in there you our Parents and kids.
You could create a self relationship. Or you could create a relationship between rows but using the function relate
to answer You cannot create standard lookup / relationships on anything other than that column.
you can create secondary++ keys which could be foreign keys to other tables. So you could then do filters/lookups etc easily to other tables.
So that is the answer.
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
