Skip to main content
Question

Add Button to Parent Table from Child Table

  • August 29, 2023
  • 0 replies
  • 80 views

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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    AdamKrzyzanek
    Forum|alt.badge.img+10

    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
    ------------------------------
    Terms & ConditionsAccessibility statement