Forum Discussion

EthanBrunhofer's avatar
EthanBrunhofer
Qrew Member
9 months ago

Add Button to Parent Table from Child Table

Greetings,

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. 

Thanks



------------------------------
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)
    mark.shnier@gmail.com
    ------------------------------
  • 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
    ------------------------------