Sorry for the numpty newby question but I wonder if anyone could help. I have been looking at this for hours!
I have a series of spreadsheets that describe the config of a system and on many tabs in the multiple spreadsheets there are places where the name of a DLL to be called is recorded. I have uploaded all of the tabs across all of the spreadsheets into a series of tables in Access.
What I would like is a master list in a table of all referenced DLLs so I can easily see them all (I know I could query the many tables to get this) and so with links in place I can then easily impact assess where a DLL has changed by searching for all places where the DLL is used.
The picture is a much simplified version of what I am after.
In the picture of my simplified example we have a table 'Forms' and two fields in there could contain a DLL name. We also have another table "Fields", again with a field where a DLL name could be stored.
Is there a way by joining the tables to make it so the DLLs table gets populated automatically where an entry is placed in either the Forms or Fields tables?
Thank you in advance.
I have a series of spreadsheets that describe the config of a system and on many tabs in the multiple spreadsheets there are places where the name of a DLL to be called is recorded. I have uploaded all of the tabs across all of the spreadsheets into a series of tables in Access.
What I would like is a master list in a table of all referenced DLLs so I can easily see them all (I know I could query the many tables to get this) and so with links in place I can then easily impact assess where a DLL has changed by searching for all places where the DLL is used.
The picture is a much simplified version of what I am after.
In the picture of my simplified example we have a table 'Forms' and two fields in there could contain a DLL name. We also have another table "Fields", again with a field where a DLL name could be stored.
Is there a way by joining the tables to make it so the DLLs table gets populated automatically where an entry is placed in either the Forms or Fields tables?
Thank you in advance.
