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

 

[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

 

[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