Update multiple table data in the same form

The basic FORM template updates only one table but that does not prevent you from embedding source code to do the remaining. If you are using ABC and you want the update of the Secondary files to take place after the Primary file update, the embed point is Window Manager --> Take Completed --> after Parent Call. The code would be like :

IF NOT ReturnValue ! if primary file update was sucessful
Relate:SECFILE1.Update()
Relate:SECFILE2.Update()
...
END

If the the procedure is a basic WINDOW procedure, you could place the code in the EMBED of the OK button.

In your case the INVOICE would be the Primary File and CUSTOMER would be the secondary file.

Hi,

A cool way to do what you want is to declare a VIEW. Look in the help it shows how to do it.

Valery.

I think there will be a problem with a VIEW as it updates only the PRIMARY table and not the SECONDARY ones.

TNX Vpos and ShankarJ,,, I really apreciate your help.

And it works great.