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" <naron@nospam.dodo.com.au>
wrote:
[color=blue]
>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
>[/color]
**********************
Join Bytes!
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
