Forum Discussion

EthanBrunhofer's avatar
EthanBrunhofer
Qrew Member
2 years 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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    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
    ------------------------------
  • AdamKrzyzanek's avatar
    AdamKrzyzanek
    Qrew Captain
    2 years ago

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