If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Related record
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? |
#2
|
|||
|
|||
Related record
Jose Lopes,
the tables look to be set up correctly for the relationship to work. The message could be appearing because the images form has not opened to the correct rec_id from the records table. Very often people use a main form with sub form setup - because if you do it this way, access makes sure that you only add images for a record selected from your records table. You would use a form based on Records for the main form and the subform based on the table images. The wizard can set up the main form and sub from for you. You can then make changes to suit if you wish. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "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? |
#3
|
|||
|
|||
Related record
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? |
Thread Tools | |
Display Modes | |
|
|