Search results

Hi, thanks for your help. i already created the tblItemREgion. and i created a query SELECT tblREgionItem.itemID, tblRegion.regionName FROM (tblRegionItem INNER JOIN tblRegion ON tblRegionItem.regionID = tblRegion.regionID) INNER JOIN tblItem ON tblRegionItem.itemID = tblItem.itemID WHERE...

Hi, I'm new to the forum. I have two tables, items and regions. the relationship is many to many. in my form, i have a listbox which shows which regions are connected to each item. my listbox currently displays all the regions available and not just the regions connected to each item. can you...