First, thank you in advance for any help you offer.
I've been tinkering with SQL for a MS Access program and have a problem with what I am trying to do.
This SQL creates a combination of all Name.Name_ID and all Requirement.Requirements_ID. It appends it to my Table called Combo with fields: Name_ID and Requirement_ID. My code always appends the entire combination of IDs to the table instead of just new combinations. I tried making the the ID's in my Combo table to be a single Primary Key, but then I get an error with the combinations that I are the same.
Here is my code:
INSERT INTO Combo ( Name_ID, Requirement_ID )
SELECT DISTINCTROW Name.Name_ID, Requirement.Requirement_ID
FROM Name, Requirement;
Here's one workaround: Run a select query on Name and Requirement, run a "Find Unmatched" query (created from the wizard) between that and the Combo table, then run and append query off of the Unmatched query to the Combo table.
Option 2: If your program design allows it, delete all the records from the Combo table then run your current SQL.