| forms6i [message #80986] |
Sun, 22 December 2002 12:04  |
murli
Messages: 25
Registered: November 2002
|
Junior Member |
|
|
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)
|
|
|
|
| Re: forms6i [message #80987 is a reply to message #80986] |
Sun, 22 December 2002 16:31  |
Julie
Messages: 98
Registered: February 2002
|
Member |
|
|
|
Why don't you build a view of your query and base your form off the view? Or you can base your block on the A table, populate the values from B in the post query trigger of the block and put the exists subquery in the where property of the datablock.
|
|
|
|
| Re: forms6i [message #80992 is a reply to message #80986] |
Sun, 22 December 2002 20:51 |
murli
Messages: 25
Registered: November 2002
|
Junior Member |
|
|
Julie
mdescription is coming from table1 and product and
volume is coming table2 and i have created a relationship within these two blocks.please let me know how about doing.
Regards
|
|
|
|
| Re: forms6i [message #80997 is a reply to message #80986] |
Mon, 23 December 2002 04:56 |
Solve
Messages: 38
Registered: December 2002
|
Member |
|
|
Julie, and mabe you know the answer to my question
"combo box" it is displayed below?
Actually I need to populate values in combo box then insert a new record . Please help me:)
Best regards and Merry Christmas!!!!
Solveiga
|
|
|
|
| Re: forms6i [message #81015 is a reply to message #80986] |
Thu, 26 December 2002 04:45 |
Balamurugan.R
Messages: 91
Registered: March 2001
|
Member |
|
|
Hi,
I think u can use the subquery in the block's
propery=> where=> ....
I think ur problem will be solved. But instead of
using tablename.columnname, use blockname.columnname;
I think ur problem will be solved, if u use this
strategy.
Let me know whether this would solve ur problem or not.
With Regards,
Balamurugan.R
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
