Duplicate entries and calling query from Form

[Jray9242]

I created a query that I thought would only add new records. I seem to work if I call the query standalone, but when I call it from the form, it adds all the records. I have included the SQL and the command I use to call the Query.



FName should be a unique name.

Thank you for the help.

QUERY:

INSERT INTO [Catalog] ( FName, FPath, FileLink )
SELECT CatalogImport.FName, CatalogImport.FPath, CatalogImport.FileLink
FROM CatalogImport LEFT JOIN [Catalog] ON Catalog.FName = CatalogImport.FName
WHERE Catalog.FName Is Null;

FORM:

DoCmd.OpenQuery "MergeData"

[Bulzie]

Should it be

WHERE CatalogImport.FName Is Null;?

[Jray9242]

Catalog is the master table and the Import is the Import table. So if Fname exist in Catalog, don't add it.

[Bulzie]

INSERT INTO [Catalog] ( FName, FPath, FileLink )
SELECT CatalogImport.FName, CatalogImport.FPath, CatalogImport.FileLink
FROM CatalogImport LEFT JOIN [Catalog] ON CatalogImport.FName = Catalog.FName
WHERE (((Catalog.FName) Is Null));

Swap the fields after ON

[Jray9242]

Nice!

Thank you for the help.