I have a problem regading the look up field I created for my products table in access 2007, this look up field is designed to include several note numbers from a source note table for the products , but when I want to get the query of one of the products which has 3 notes inside, it loads the whole product info three times and each time, one of the three notes is displayed, How Can I merge all the notes results in a single field ? is this possible ?