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