Forum Discussion

33195's avatar
Qrew Member
3 years ago

Import/Export Functionality

We have created an app to gather data from several tables to provide consolidated reporting. I would like to be able to create a link from each line of the table back to it's original database. I can create the link, but it links all lines in my reporting table to a single original database, not the one specific to each line.

For example Reporting table contains lines from Table A, Table B & Table C.

If I create a link to table A as one of the fields in the reporting table, it points all lines to Table A. Lines from Table B are obviously not found in Table A.  I don't want to have to create a different field for each Table, as this creates these extra fields on every line.

A,B,C is a simplified explanation...we are using upwards of 20 tables to combine the reporting data.

Any solution for this??

1 Reply

  • If I understand the question, you need an IF ..

    [Related Table A] >0, URLRoot() & "db/" & [_DBID_TABLE_A] & "?a=dr&rid=" & [Related Table A],
    [Related Table B] >0, URLRoot() & "db/" & [_DBID_TABLE_B] & "?a=dr&rid=" & [Related Table B],
    [Related Table Z] >0, URLRoot() & "db/" & [_DBID_TABLE_Z] & "?a=dr&rid=" & [Related Table Z])

    Mark Shnier (YQC)