| Form Problem [message #222934] |
Wed, 07 March 2007 00:28  |
u263066
Messages: 47
Registered: March 2007
|
Member |
|
|
Guys,
I have 2 table a and b for master and details blocks.
Now on the master block, there is one non database feild called 'X' which is basically deptid of third table called Dept.
the details are in tabular form with number of records is set to 3.
The field X has LOV and based out of select deptid from dept. There is button called "" on pressing want to display data based by filter chossen in LOV.
2 column of the table b need to pupulated by the value from emp table based out of filter of dept LOV.
Lets say user has selected Dept 30 and in emp table there are 6 records for this department. I want to populate two of the field of B data elemnents.
I did by useing cursor but what it only display last row of the data set in first element of tabular row.
can anyone advice how to achive, this.
Thanks in advance
|
|
|
|
| Re: Form Problem [message #223016 is a reply to message #222934] |
Wed, 07 March 2007 03:44  |
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
|
Senior Member |
|
|
Hi,
Sounds like you might have missed a next_record in your cursor loop, meaning it's not moving onto the next record in your block b?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
