Hello all,
I am writing a form programming where I have to fill table T3 from two tables
T1 and T2 upon a button click.
I have a complecatd query Q1 on T1 & T2 whose output should be inserted into
T3.
Would anybody help me how to achieve this in form programming.
If I write query as SELECT ....... FROM T1, T2 ......etc.... and double click
on it, I am getting the list of rows I wanted.
If I write query as INSERT INTO T3 SELECT ....... FROM T1, T2 ......etc....
and double click on that, all these rows are inserted into T3.
But the question now is, how to execute this with FORM PROGRAMMING.....
Any help is appriciated ....
Thanks
Sri