Conditionally Append Rows...is it Possible?

[jmalcolm]

Hey guys!

I have a problem. I am currently working on a project where I am required to look through a couple Databases (originally from Foxpro). One is a full contract list (roughly 2100 rows), the other is one huge database of all the members and the contracts they are committed to only (almost reaching 500,000 rows).

My question is this, Is there a way to run an Append query that can check the member contracts and what they are committed to, and then compare it against the full contract list. If the Contract from the full list is not in the member contract committment list, then add it to that database.

I hope this is possible, I've been racking my brains thinking of the logic involved. Seems simple, but committing it in the language is harder. Will I have to use VBA script with SQL?

Any help is appreciated, thanks alot!

[MMcCarthy]

Hey guys!

I have a problem. I am currently working on a project where I am required to look through a couple Databases (originally from Foxpro). One is a full contract list (roughly 2100 rows), the other is one huge database of all the members and the contracts they are committed to only (almost reaching 500,000 rows).

My question is this, Is there a way to run an Append query that can check the member contracts and what they are committed to, and then compare it against the full contract list. If the Contract from the full list is not in the member contract committment list, then add it to that database.

I hope this is possible, I've been racking my brains thinking of the logic involved. Seems simple, but committing it in the language is harder. Will I have to use VBA script with SQL?

Any help is appreciated, thanks alot!

To help with this we will need the metadata of the tables involved.

Here is an example of how to post table MetaData :
Table Name=tblStudent

Field; Type; IndexInfo
StudentID; AutoNumber; PK
Family; String; FK
Name; String
University; String; FK
Mark; Numeric
LastAttendance; Date/Time