Skip to main content

Link calculated field to a PK in another table

  • July 3, 2018
  • 2 replies
  • 40 views
A

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

    E
    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.

    A
    • Andrew_White
    • Author
    • New Participant
    • July 4, 2018

    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