Store correct value in Junction Table with form controls

[mduplantis]

Hello,


I am working with 3 tables (tblPERS, tblPPEAssigned,tblPPE), one of which is a junction table (tblPPEAssigned). I have created a main form (Personnel Overview) and have used a query to create a subform of my main form.
I also have set up a form (Assign PPE) using the form controls to add new values to the fields (PERSID and PPEID) which are my FK. Although I kind of have it working, it appears I am not storing the FK values, but instead story the 2^nd column of my outside tables.

Below is a diagram of my problem.

My goal is to have the user make a choice from the combo box that is familiar to them, but store the correct FK in the table. My attempt was to use form controls, but maybe this is better accomplished in the table design?



Thanks for any help

[ItsMe]

Is your combo a bound combo? Perehaps you need to adjust the Bound Column property.
https://msdn.microsoft.com/en-us/lib.../ff822489.aspx

[mduplantis]

Hi,

Yes, it is a bound property and it is set to 1. I attempted to change to 0, but it gave me warning. I'm trying to figure out how to attach a copy of the database to the question.

Thanks

[mduplantis]

I found the FAQ on how to upload a file, but I can't seem to find the controls.

Here is the database until I figure it out.

https://www.dropbox.com/s/t8cgc0cnfl...151.accdb?dl=0

[mduplantis]

I as able to solve my problem. I had to change my original query and also a few of the form properties with the combo box. Thanks fo r looking.

[ItsMe]

Sorry I was not able to respond earlier, but I am glad you were able to sort out the issue.