Skip to main content

Link calculated field to a PK in another table

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.

    This topic has been closed for replies.

    2 replies

    Forum|alt.badge.img+17

    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.

    Terms & ConditionsAccessibility statement