Link calculated field to a PK in another table



I have a seemingly simple issue I cannot solve.

Table “Prices”:
Primary Key: Band
Lots of other columns

Table “Clients”:
Calculated Field: Band (Calculated by multiple factors in the table Clients)

How can I access the other columns in Prices via joining on Band? I can’t make it a linked field as it is calculated??



Could you explain deeper you base? If you want to relate Prices with Band, you have to create a Linked Record field to link them, not just write it in the Primary Field.


As mentioned the Band column in Clients is calculated. As far as I can see you cannot created a linked field on a calculated column.