Forum Discussion

ShalomEguale's avatar
ShalomEguale
Qrew Trainee
3 days ago

Button to go to related record in a different table

Hi,

I have 2 tables, I would like to add a button in the form from the Accounts table that takes me directly to the related record in the Findings table. Both tables have the same Account ID field so I have created a table to table relationship between the two. I'm assuming I can achieve this with a url field with a formula that some how finds the related record in the Findings table by matching the account ID# but I have no idea what that formula would be. Please help

Thanks

formulas

1 Reply

  • DonLarson's avatar
    DonLarson
    Qrew Elite
    3 days ago

    If you have related the two tables, the Child Table will automatically get a field to the Parent Record.

    Here is a picture from a relationship.   

    The field Related Parent and Parent-Name should both be links back to Parent.

    If I misunderstood your question, please expand.