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 relation****p 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?
