Sub Form doesn't record

[kylukru]

Hi there,

I hope you will be able to help! My problem seems basic but I have spent the last couple days on it without success.

Here we are: I have got a data base with the traditional form linked to a subform. The subform uses multi tables. When I fill a record in the subform then go to another record in the main form and come back to the previous record, the record I had filled in the subform is not saved at all.

The subform enters data to up to 7 different tables. I noticed that if I only use 3 different tables I have no problems recording the data and switching from record to record but as soon as I base myself on more tables I can't save my records.

Any suggestion?

 

[ansentry]

I am just curious why would you have a single subform linked to 7 different tables?

Maybe you need to read up on normalization.

 

[kylukru]

I use the form to gather information on retailers that are our customers. For each visit I get feedback on a lot of different areas (customer satisfaction, brand representation, retailers knowledge, end-user profile etc.). I created one table for each type of feedback to avoid to have too much information on a single table. I then used a single subform to enter the data on these tables for each visit.
I don't know about normalization. May be it means I should create one subform per type of feedback?