Access Form to merge select data from table 1 &2 to 3
I need to do the following with an Access Form:
1. Look up data with a combo box from "Table A"
2. Based on what was chosen from "Table A" User will choose up to 5 different check boxes on form.
3. This record with choice from "Table A" and check boxes picked needs to be saved into "Table B" which will have 6 fields.
This seems simple but I am struggling for some reason.