Forum Discussion

EthanBrunhofer's avatar
Qrew Member
9 months ago

Add Button to Parent Table from Child Table


There is Table A (parent table) and Table B (child table). Both tables are children of parent Table X. I need a button or link on a report from Table B. The button should open a record on Table A that I classified as "active" on Table X by a summary field.  

Is there any way to do this? 

Alternatively, I need to create a way to relate all records from Table B to a specific record ("active") from Table A. The "active" record will change as the status of that record progresses. 

Any tips or advice would be appreciated. 


Ethan Brunhofer

2 Replies

  • It hard for me to understand the ask here.  Would you be willing to restate your question using the real names of your tales instead of the A B and X?

    Mark Shnier (Your Quickbase Coach)
  • Try this for Table A and repeat for Table X

    //Show Table A
    // here [_DBID_TABLE_A] you should place your Table name from Advance settings
    "<a href='" & URLRoot() & "db/" & [_DBID_TABLE_A] & "?a=q&qid=1" & "&query=
    //120 = Field number in Table A you want to compare for field from Table B
    //EX = Exactly
    //Related Table A - field from your Relationship.
    {120.EX." & [Related Table A] &"} AND
    //31 = field number in Table A which show if classified
    {31.XEX." & "active" &"} 
    '& target=\"_blank\">"&"Active Table A"&"</a>"  

    Adam Krzyzanek