Access 2003 records in form disappear

[GuiGirl]

I am not sure what I am doing wrong. I have two tables that are a manay to many relationship. tblCareOptions and tblFacilities. I reviewed some of the wonderful threads in the tables forum. I visited Microsoft Access Help for relationships and forms. I've visited some of the Access tutorials and discussions on the web. I thought I had it but for some reason, I am still missing something. Problem:After entering care option values from a dropdown list on my CareOptions subform--"I did this for 10 records as a test" the careoptions i entered disappear after i close the form.
tblCareOptions
pk = CareOptionsID (Autonumber)
one field = CareOptionsDetail (lookup)
tblFactilies
pk = FacilNumberID (Autonumber)
facilitynumber (number)
Facilityname (text)
FacilTelephoneNumber (itext)
tblFacilCareOptionjoin
pk = FacilCareID (Autonumber)
fk = FacilNbrID (Number)
fk = CareOptionsID (Number)
I created a CareOptions form. I also created a CareOptions subform on my Facilities Form linking CareOptionsID as Child Field and FacilNbrID as Master Field. I thought I had it working but to my chagrin no. I tried a few other links then tried basing my CareOptions form on a query. I linked my tblCareOptions to TblFcilCareOptionjoin.
I am at a loss for getting a choice of CareOptions to link to each facility.
I appreciate advice to get this DB working.

Thanks

 

[RuralGuy]

I've found that Lookup Fields just confuse the programmer. How about you?

 

[ajetrumpet]

I've found that Lookup Fields just confuse the programmer. How about you?

i have had that link ever since i joined this site Alan.

 

[GuiGirl]

Hello all,

I found my solution. I appreciate all that have responded to me. I am a visual learner and found an example at www.rogersaccesslibrary.com on M:M relationships. I have some tweaking to do on my DB . Many thanks to BobLarson for recommending this great website to novice Access users.

Thanks again to all