Hi Chaps,

Many years ago I created a number of databases in foxpro and access, and am now trying to create the most simple of client contact databases for my small company.

I have Microsoft Access 2007 but time has done me no favours and I'm struggling to achieve something which should be very simple. I can't get my head around how I set up a relationship between 'Attendance Notes' and 'Clients' tables.

Tables are:

Tbl Client-
1) Key
2) Company name
3) Contact name, position, telephone number etc

Tbl Att Note-
1) Key
2) Type of contact
3) Date/time of contact
4) Notes
5) Next steps

I then have a form for both tables, and have embedded the Frm Att Note into the Frm Client.

The Frm Att Note is a Multiple Items template.

However, the notes displayed bear no correspondence to the record showing in the main Client form.

I'm obviously missing something, and knowing me it's probably something stupid but I can't figure out how to link it so that the attendance notes shown relate only to the record shown on the main Client form.

Erm, help please?!

Thanks in advance for your patience.

You would have this:

Tbl Client-
1) ClientID - Autonumber (Primary Key)
2) Company name
3) Contact name, position, telephone number etc

Tbl Att Note-
1) AttNoteID - Autonumber (Primary Key)
2) ClientID - Long Integer (Foreign Key)
3) ContactTypeID - Long Integer (Foreign Key)
4) Date/time of contact
5) Notes
6) Next steps

You then link on ClientID which ties them together.

Aha, that worked perfectly, thank you very much, incredibly helpful of you :)

Matt.