D
DataDiva via AccessMonster.com
Hello,
I have two tables with a one-to-one relationship through the ID field. I
created a form (frm_Incoming_Inspection) for the first table that has a
command button to open the second form (frm_Incoming_Meas). The second form
is only used to record dimensional measurements about material on the first
form. I would like to be able to filter through the records on
frm_incoming_Inspection and press the command button to open
frm_Incoming_Meas and have the corresponding information to the inspection
form show up. I also need to be able to enter new records using both of these
forms. The one-to one-relationship shows me the correct info from a saved
record but it won’t let me save any data in frm_Incoming_Meas because it
requires a record in frm_Incoming_Inspection first. Does anyone know of a
simple way to accomplish this?
Thank you,
Courtney
I have two tables with a one-to-one relationship through the ID field. I
created a form (frm_Incoming_Inspection) for the first table that has a
command button to open the second form (frm_Incoming_Meas). The second form
is only used to record dimensional measurements about material on the first
form. I would like to be able to filter through the records on
frm_incoming_Inspection and press the command button to open
frm_Incoming_Meas and have the corresponding information to the inspection
form show up. I also need to be able to enter new records using both of these
forms. The one-to one-relationship shows me the correct info from a saved
record but it won’t let me save any data in frm_Incoming_Meas because it
requires a record in frm_Incoming_Inspection first. Does anyone know of a
simple way to accomplish this?
Thank you,
Courtney