Jose

A more common approach would be to embed that second form inside the first
as a "subform", and to use the subform control's parent and child properties
to link the two together. That way, any subform record you add will be
added within the context of the main form record you are starting with.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"Jose Lopes" wrote in message
...
I’m not experienced with database design so I’m calling for some help.

I have two tables one called RECORDS and another called IMAGES

RECORDS
- REC_ID (PK)
- DATE_
- MEMO

IMAGES
- IMG_ID (PK)
- IMG_REC_ID (indexed, with a relationship to REC_ID)
- IMG (OLE type)
- IMG_MEMO

This will be used to record accident situations and there will be a few
photographs taken for each situation. I was able to create a form to input
the RECORD data. Then I used the assistant to create a button that will
open
a new form (IMAGES FORM) where I want to introduce the images for that
REC_ID. The problem is, after in copy paste my images in the form, when I
try
to close it, ACCESS will say that a record is necessary in the RECORDS
table…
I thought that the necessary record was already created while inputting
data
in the RECORDS form… what am I doing wrong?