I have a table that is my main table(titled Working). In addition to other fields I have a field titled AutomationID and another titled DealerID. I download this main table on a monthly basis. There are many records that do not have a DealerID.
I have a secondary table that I want to use to handle data I receive on a monthly bases that has no DealerID. When I get a record with no DealerID I need to manually insert the dealer ID in the main table. I want to use this secondary table to store records with both a AutomatinID and a DealerID. I can then use this table to update the main table and eliminate the excessive manual process.
I need a query that will look at the main table and select the records without a DealerID that is not already in the secondary table. I will then update the main table with the DealerID from the secondary table using the AutomationID to match the DealerID. My monthly data import always has the AutomationID.
I assume I need to use NOT EXIST in my query but I can’t seem to figure out how to do this properly.
Any assistance is appreciated.
Ron--
I have a secondary table that I want to use to handle data I receive on a monthly bases that has no DealerID. When I get a record with no DealerID I need to manually insert the dealer ID in the main table. I want to use this secondary table to store records with both a AutomatinID and a DealerID. I can then use this table to update the main table and eliminate the excessive manual process.
I need a query that will look at the main table and select the records without a DealerID that is not already in the secondary table. I will then update the main table with the DealerID from the secondary table using the AutomationID to match the DealerID. My monthly data import always has the AutomationID.
I assume I need to use NOT EXIST in my query but I can’t seem to figure out how to do this properly.
Any assistance is appreciated.
Ron--