Table Design 1 to Many Relationship Question in Access 2007

C

cbianco

I need to have multiple notes for clients. I have my client table and my
notes table. On my client form I have multiple subforms with one of those
subforms being the notes table. The notes subform should populate the current
date and time and allow me to type the new notes. This all works fine.

Problem - when I try to move to another record, I get a repeat of my client
information because it keeps going through each note.

Any suggestions?

Thank you.
 
F

Fred

It's not totallly clear what the (symptoms of ) the problem you are
experiencing are but......


Start by making sure you have a good table structure in place and no
problems with the data in the linking fields.

Make sure that your linking field in the Client's table is set to be a
primary key and that it IS linked to your notes table.
 
A

Armen Stein

I need to have multiple notes for clients. I have my client table and my
notes table. On my client form I have multiple subforms with one of those
subforms being the notes table. The notes subform should populate the current
date and time and allow me to type the new notes. This all works fine.

Problem - when I try to move to another record, I get a repeat of my client
information because it keeps going through each note.

Make sure your Notes table isn't included in the recordset behind your
main Client form.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top