So for argument sake lets assume that what I am trying to do has to be done in a table and without the use of forms (becasue its what works for us) in Access 2007.
I have a table where my staff records a number of different data fields for accounts. I currently have a 3 table relationship established. One of these table is our "Notes" table. My staff enters continuous notes for different accounts as new information come in.
What I have done is set my "date" field's default value to "now()" which accomplishes the time-stamp I need, but at the same time as soon as they type anything in another field in that row Access creates another row which is unwanted. Can I prevent this, and as a follow up how can I go about also having a field that auto fills w/ the user's name/ID?
I have a table where my staff records a number of different data fields for accounts. I currently have a 3 table relationship established. One of these table is our "Notes" table. My staff enters continuous notes for different accounts as new information come in.
What I have done is set my "date" field's default value to "now()" which accomplishes the time-stamp I need, but at the same time as soon as they type anything in another field in that row Access creates another row which is unwanted. Can I prevent this, and as a follow up how can I go about also having a field that auto fills w/ the user's name/ID?