Hi,
I don't have Access at home so can't try this until Friday when back to work. But, just to be clear, is this what you mean?
SELECT tblPlatformDetails.PlatformID, tblPlatform.PlatformName
FROM tblLocation INNER JOIN tblPlatformDetails ON tblLocation.LocationID =...
Hi,
I have 2 Combo boxes that I want to synchronize using data from 3 tables:
Table 1: tblLocation
LocationID, LocationName
Table 2: tblPlatform
PlatformID, PlatformName
Table 3: tblPlatformDetails
LocationID, PlatformID
Table 3 is the Junction Table to create a many to many relationship...