I am currently working on a database with 3 Tables. 1 is the customer list (657) with all their details, 1 is a contract list (2011) with all those details and the 3rd is a complete customer list with all the current contracts they are committed to (486,974).
What I need to do is find a way to add all the contracts (committed to or not) to the complete list. This seems simple enough, but I can't seem to find a way to do it. So i decided I would do one big split off into 657 tables, run a VBA or SQL script to look through which contracts are already inside the complete list and if it's already there, then skip it, if it's not, then append it to a new row.
Since I'm horrible at explaining, and some of that might not make sense, let me write my pseudocode:
[code]iCount = 0
IF . = . THEN
APPEND . to .
iCount = iCount + 1
WHILE iCount <= 2011[/code]
Basically something like that, unless someone has a way for me to do this all in JetSQL. Any help is appreciated!
Thanks in advance.