Hello, Excuse me please if I do a silly question. But the truth is that I could not change the default value of saldo_actual field from the cliente table. As much as I put in value If required, I deleted all records from the cliente table and have even removed all relationships with other tables, just do not let me, I can not just save the changes made and the cursor is just saldo_actual field. It seems very strange that there must be something I'm not understanding. Much appreciate an answer, regards, Yessica Brinkmann
2013/2/3 Ariel Constenla-Haile <arie...@apache.org> > On Sat, Feb 02, 2013 at 11:39:23PM -0300, Yessica Brinkmann wrote: > > Thank you for the answer! I put my database on mediafire, the link is as > > follows: > > http://www.mediafire.com/?bhzhr0zzkcz1iue > > The macro that I have problem is associated with the button Calcular > Total > > on Ventas form. > > On a first quick look, your table "cliente" needs a default value of > 0 in the field "saldo_actual", otherwise it will fail in the UPDATE > statement when it is incremented. > > > Regards > -- > Ariel Constenla-Haile > La Plata, Argentina >
