For this retail example, I am importing sales data into a Sales table, which automatically updates the Inventory table. Here’s what I want to solve for:
As file is being imported into Sales table, check productID against Inventory table to see if productID exists, if it does not, do not import.
Thanks for your help!
Ok, one thing you can do is create a view where, productID is blank, and then just bulk delete those imported rows or you can remove them prior to import in excel with a macro.