Join problem

[jsimes]

I have a Contacts table and a Notes table, I would like to make a query that gets all of the fields from the Contacts table and also gets the multiple records for that contact from the notes table.

The contacts can have many notes there is a contactID in the notes table to join it to the contacts table.

Ideally I would like to get back:
contactID, ContactName, Note_1, Note_2, ... Note_x

in one record instead of:

contactID, ContactName, Note_1
contactID, ContactName, Note_2
contactID, ContactName, Note_3
...
contactID, ContactName, Note_x

does this make sense?

Thanks for your help,

Joe

 

[hjgoldstein]

In your main form, I would suggest that you create a sub-form of the notes table and display it as a datasheet within the main form. That way you'll see all the relevant records from the notes table as if they were the result of a query.

Hope this helps.

Howard.