Many subforms from one table

[mattpearcey]

I have a table that i have inherited from another system, that is not normalised at all, and in essense - is one huge table. I cannot get rid of this, as i need to hold this info. However, i have managed to get this to look respectable in a form, but in order to make them relate to the records i need it to, i have broken the form up into many subforms. Therefore, when going into the record, all the subforms match up to the id from the main form - thus keeping it all related.

However, now that i am entering records, it is misbehaving, and each subform adds a new record everytime i add inform into it. So, for example, i enter info on the first tab into on subform, then go onto the next tab and enter info, and so on. But when i go back into the record later, it shows that there are say 5 records. And, when i go into each subform, the info that i have entered is added as a new record.

So - Subform on shows info as record one of 5. Subform 2 only shows info at the 2 record of 5, and so on. So it is all messed up. How can i get them to all match up to the same record.

I have tried doing this all in one form, but when, on the wizard i select it to show specific data, matching ID from Main form to ID from the New form - this does not work.

Any ideas? Thank you for your help already.

Matt Pearcey

 

[DougP]

The reason the subforms and main form is misbehaving is because you have a Primary KEY.
Access has a glitch for several version now that will not allow a subform to do something different other than sync to the main form.

If you remove the primary key then this problem will go away.
Now you say it will be slow. Well that depends on the CPU and your network speed.
If you have P4 with 384 Meg on a 100Base-T network it will not be slow.
I never use a Primary key ever. For the above reason I need the flexibility of having subform do what I want them to do.

Choose define my own link when creating a subform but leave it blank.
DougP, MCP