Search results

  1. A

    Using a junction table to populate synchronized Combo boxes?

    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 =...
  2. A

    Using a junction table to populate synchronized Combo boxes?

    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...
Top Bottom