If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table Design 1 to Many Relationship Question in Access 2007
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. |
#2
|
|||
|
|||
Table Design 1 to Many Relationship Question in Access 2007
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. |
#3
|
|||
|
|||
Table Design 1 to Many Relationship Question in Access 2007
On Tue, 19 May 2009 10:15:01 -0700, cbianco
wrote: 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 |
Thread Tools | |
Display Modes | |
|
|