Home » Developer & Programmer » Forms » Form Problem
Form Problem [message #222934] Wed, 07 March 2007 00:28 Go to next message
Messages: 47
Registered: March 2007

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 Go to previous messageGo to next message
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member

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?

Re: Form Problem [message #225413 is a reply to message #223016] Mon, 19 March 2007 22:21 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Populate block using cursor
and my feelings about it.


Oops! I pasted the wrong links.

[Updated on: Mon, 19 March 2007 22:22]

Report message to a moderator

Next Topic: regarding form size(URGENT)
Goto Forum:

Current Time: Wed Aug 23 09:02:24 CDT 2017

Total time taken to generate the page: 0.03530 seconds