Thanks Ray - I thought I already had a recordset:
SELECT DISTINCT LodgeID, Lodge, GSG_URL, banner_image_new, Country, banner_image_new_title, photo_one, photo_one_title, Summary_2013, lodges.CountryID, UserIDIT FROM lodges INNER JOIN countries ON lodges.CountryID = countries.CountryID INNER JOIN product_users ON lodges.LodgeID = product_users.LodgeIDIT WHERE Product_Type = 'Property' AND UserIDIT <> '' GROUP BY LodgeID
And the loop, which is displaying all the records with the tick boxes.
Or do I need a second one to control whether or not the tick boxes show as ticked?
Where do I use 'manage relational table' instead of 'multiple insert'?