I have a form and on that form I have a combo box [ProdLocID] that I want to only show values based on a value in the other combobox [ProductID].
I have products in locations. I want [ProdLocID] to only display the only existing locations for the [ProductID]
ProdLocID is in the table called ProdLocations and ProductId is in the table Products.
What criteria can I place in the query to do this?
Here is what I tried so far but it gives me all the ProdLocID of all the ProductID
SELECT ProdLocations.LocID, Locations.LocNm
FROM Locations INNER JOIN ProdLocations ON Locations.LocID = ProdLocations.LocID
ORDER BY ProdLocations.LocID;