Using a junction table to populate synchronized Combo boxes?

[lb.access]

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.

I managed to get the two combo boxes to synchronize using the following query:

SELECT tblPlatformDetails.PlatformID
FROM tblLocation INNER JOIN tblPlatformDetails ON tblLocation.LocationID = tblPlatformDetails.LocationID
WHERE (((tblLocation.LocationID)=[Forms]![frmLogEntry].[cboLocation]));


The problem is the second combo box is auto-populated with PlatformID after Location is selected but I would like it to be populated with PlatformName instead.

I am a newbie and struggling to figure out how to do this. Any help would be most appreciated.



Thanks in advance

[CJ_London]

rather than tblLocation you need to include tblPlatform in your query, then you can select the name