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??
Thanks
Vonda