Hi,
I have several spreadsheets that drive solid models (Inventor). I want to link them to Acces in order to produce Bills of Materials. Since design revisions are common, this allows updating the models and spreadsheets at the same time, lessening errors. I have made all the reports that are necessary. My question is what is the best way to change the data sources of the queries and reports to reflect a particular job. Do I leave each linked table separate, and change the table reference with code, or can I have one table linked to many spreadsheets which I can query by JobName?
Thanks in advance,
LHWC
I have several spreadsheets that drive solid models (Inventor). I want to link them to Acces in order to produce Bills of Materials. Since design revisions are common, this allows updating the models and spreadsheets at the same time, lessening errors. I have made all the reports that are necessary. My question is what is the best way to change the data sources of the queries and reports to reflect a particular job. Do I leave each linked table separate, and change the table reference with code, or can I have one table linked to many spreadsheets which I can query by JobName?
Thanks in advance,
LHWC