I just went back and looked at my query and something is terribly wrong.
When I open my form to enter new information... I use the combo box to choose a facility. Each facility has an ID but I choose the facility name since the ID would be too difficult to remember for over 200 facilities.
But now... when I choose the facility from the combo, the address fields automatically fill in via (Combo17.column(2), etc.). And then I manually enter the review information. But now, I go back to the query and it is creating a new ID for each review. So instead of repeating multiple facility IDs (because they have multiple reviews) it is adding a new ID and then storing the facility ID under the facility name and not pulling any of the address information.
You guys are probably all thinking I am completely incompetant in this, and I am sorry to admit that I am. But I learn quick and have gathered various resources and materials but am having no luck.
Any suggestions on this problem?
Thanks
Nicole
When I open my form to enter new information... I use the combo box to choose a facility. Each facility has an ID but I choose the facility name since the ID would be too difficult to remember for over 200 facilities.
But now... when I choose the facility from the combo, the address fields automatically fill in via (Combo17.column(2), etc.). And then I manually enter the review information. But now, I go back to the query and it is creating a new ID for each review. So instead of repeating multiple facility IDs (because they have multiple reviews) it is adding a new ID and then storing the facility ID under the facility name and not pulling any of the address information.
You guys are probably all thinking I am completely incompetant in this, and I am sorry to admit that I am. But I learn quick and have gathered various resources and materials but am having no luck.
Any suggestions on this problem?
Thanks
Nicole