Linking Main form and subform - problems!

[HelenWy]

Hi everyone

I've tried searching, but nothing came up that helped, so I'm sorry if this has been answered before.

I have a main form, which contains a subform. My problem is that when I create a new record on the main form, a new record is created in the subform (correctly) but if I go back to the previous record in the main form, the previous part of the record in the subform doesn't show! The forms are linked with ComplainantID on each, and the master/child field settings reflect this. There will only be 1 record of information within the subform for each record on the main form, so I just need them to link together - when I move back and forth on the record selector in the main form, I need to the subform to display the appropriate info!

Hopefully that all makes sense, and that someone can help? I need the subform to act as the main form does, in relation the adding/deleting/navigating through records.

Helen

 

[gemma-the-husky]

i don't understand this

1. how does creating a record on the main form AUTOMATICALLY create one on the subform

I have a main form, which contains a subform. My problem is that when I create a new record on the main form, a new record is created in the subform (correctly)

2. Why should there only be one item per subform for each mainform item

There will only be 1 record of information within the subform for each record on the main form, so I just need them to link together - when I move back and forth on the record selector in the main form, I need to the subform to display the appropriate info!

normally a mainform - subform implies a 1-many link between the sources of the two forms. You seem to have something else going on, so can you clarify this please.

 

[HelenWy]

Hi Gemma

1) I don't know, but it does. I create a new record on the main form, and the subform goes blank. This is what I WANT it to do.

2) Really, I think I need a one-to-one relationship i.e. each person makes one complaint. BUT it is likely that SOME of the people we deal with will make more than one complaint, but not all the data will be the same i.e. date received will be different, for example, and WHAT they are complaining about is not necessarily going to be the same thing as before.

Perhaps I am going about this the wrong way, I don't know.