Write Conflicts Split MUD

[scottemotive]

I have a main form and a sub form

i have a main table and a sub table

the main form is creating a record in main table and then the subform is forced to create a record in the sub table (as they are linked)
now whats happening is the main table is opening the record and then the sub form is being edited (which CAN change values on the main form and thus the main table) so when the record is saved the main table is being edited by the subform and so its saying "do you want to drop, save or copy to clipboard" etc...

if save changes is pressed the main table is updated and the sub table is updated, which is fine i mean i could just send keys to save changes each time it happens, however i dont want to do this as its a bit bodged, does anyone know of this problem, know of a solution that can help me?

thank you

 

[Pat Hartman]

does anyone know of this problem

- This isn't a problem. This is how Jet is supposed to work. When one process updates a record while another process has control of that record, there is a potential problem. That is why Jet is warning you. You are conflicting with yourself. Your subform should not be updating data in the main form's table. Review your design because there is likely to be a problem with it.

 

[scottemotive]

Pat, thank you for your advice, can you recommend a structure for it?

shall i create just one main table to hold all values from both the subform and the main form or is there another way?

thank you

Scott

 

[Pat Hartman]

Merging the two tables into one will probably create more problems. You'll need to provide more details regarding what each table contains and why the "parent" table is being updated by the "child" form.

 

[scottemotive]

thanks for your hlpe, ive resolved this problem by first storing the values on the main for that the subform changes in an unbound textbox and then before save record i copy these values to the bound textboxes bound to the main table

 

[Pat Hartman]

Let me say it again. Your subform should NOT be updating your mainform. You have a design problem.