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
|
|||
|
|||
Form Filter and Data Entry Issue
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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200910/1 |
Thread Tools | |
Display Modes | |
|
|