Link calculated field to a PK in another table

[Andrew_White]

Hi,

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??

Thanks,
A.

[Elias_Gomez_Sai]

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.

[Andrew_White]

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.