The typical solution involves two tables - a main table for your basic
table, and a child table for the comments. The items in the two tables
are related in a one-to-many relationship. The user interface for such
a relationship is typically a form/subform setup.
Explore the Northwind sample database that ships with Access or
purchase an introductory book about Access database design to find out
more details how to create these entities.
On Mon, 02 Aug 2004 10:28:25 GMT, "naron" <na***@nospam.dodo.com.au>
wrote:
Hi - I am building a DB from ms-access I have a simple GUI form to start
with that allows basic data to be added for each unit built and buttons to
bring up a separate comments field where comments are added by the
technician. However when in practice the comments field opens ok and
comments can be entered but they save to a new record.
How can I synchronise it so when the comments form is opened it adds data to
the same record the basic data entry form is recording?
I know it can be done - the help file tells me it can - It just doesnt tell
me how to do it!
Appreciate any help.
Cheers
Mark
**********************
ja**************@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security