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