Trying to avoid using subforms. Just as an example,
I have 2 tables Name and Color. I have my relationship
set up as a 1 to many. A name can have many favorite colors. I have also created 2 seperate forms. A frm_name
and frm_color. I want to execute frm_name, input a name, click a button to bring up frm_color and insert multiple favorite colors for the name I just entered in frm_name.
Using the form wizard in Access, I was able to link the 2 forms but when click the frm_name button to go to frm_color, the nameid from frm_name does not appear in the nameid field in frm_color. When I try to save the data entered in frm_color, I get the error message "you can't add or change a record because a related record is required in table tbl_name. What is going on here? I have 2 tables tble_name and tbl_color. As mentioned earlier, I am using a one to many on the nameid field in tbl_name to the nameid field in tbl_color. In my tbl_name, the nameid field ins the PK. In my tbl_color, colorid is the PK. Any help would be appreciated. Thank.
I have 2 tables Name and Color. I have my relationship
set up as a 1 to many. A name can have many favorite colors. I have also created 2 seperate forms. A frm_name
and frm_color. I want to execute frm_name, input a name, click a button to bring up frm_color and insert multiple favorite colors for the name I just entered in frm_name.
Using the form wizard in Access, I was able to link the 2 forms but when click the frm_name button to go to frm_color, the nameid from frm_name does not appear in the nameid field in frm_color. When I try to save the data entered in frm_color, I get the error message "you can't add or change a record because a related record is required in table tbl_name. What is going on here? I have 2 tables tble_name and tbl_color. As mentioned earlier, I am using a one to many on the nameid field in tbl_name to the nameid field in tbl_color. In my tbl_name, the nameid field ins the PK. In my tbl_color, colorid is the PK. Any help would be appreciated. Thank.