forms6i

[mys]

I have got two tables table1 and table2.I want to display mdescription,product and volume.I have written the below query which is working fine in sql but i have to implement in forms.I have created relationship between table1.pname,table2.pname and table1.mname,table2.tname.this relationship is working,I want to implement the subquery also in forms.Can anyone please help me out.I have to do it tommorrow.It will be a great help.



SELECT A.MDESCRIPTION,B.PRODUCT,B.VOLUME
FROM table1 A,table2 B
WHERE A.PNAME = B.PNAME
AND A.MNAME = B.TNAME
AND B.BDATE = '18-DEC-02'
AND
A.PNAME IN(SELECT PNAME FROM GROUP C
WHERE C.UGROUP = A.DENTRY)

[stecal]

Create a view, then make a data block in the form based on this view.
When you update, use triggers (pre, on, and/or post-update triggers) at the block level. Likewise for inserts and deletes.