History keeping solution/Defining data from a table in VB
What I'm trying to do is move the data of one record from one table to the next and drop off at the last table (keeping a history so to say).
History 0 => History 1 => History 2 => ... => History 14
Each Record has 40-50 datafields per table so as you can see it is too big to be stored in one query/table.
The solution I have thought of is to have queries spanning two consecutive tables and shuffling it along using a Visual Basic application.
Doing so, I've encountered difficulty in defining the data from tables usually getting the error message "External name not defined". What is the correct syntax to define the data? For example one of the tables is called "History 0" and one of the fields in it is called "Date".
The syntax I am using is:
[History 0].[Date]
obviously this is wrong, could somebody please provide me with the correct syntax for this?
Any answers concearning either another solution or the correct syntax will be appreciated.
Regards
Aaron
