Need help while inserting record in forms [message #606133] |
Mon, 20 January 2014 04:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/95c9b98450e177e0af71a941ba0ac6da?s=64&d=mm&r=g) |
nkumar0130
Messages: 55 Registered: August 2013 Location: Bangalore
|
Member |
|
|
Hi,
In my form I am having a Id column.
In form there are two blocks. each block is based on a table. And in both the table Id column is the key
The first block contain a button, so on pressing a button in first block it will open the second block.
My concern is that, after filling all the record in first block and on pressing the button it will open second block so on inserting the value in second block the value of Id column should get inserted automatically from the first block.
Any suggestion i highly appreciated
Thanks
|
|
|
|
|
|
|
Re: Need help while inserting record in forms [message #606149 is a reply to message #606133] |
Mon, 20 January 2014 06:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
nkumar0130 wrote on Mon, 20 January 2014 12:53
Because In first window there are three blocks(A1,A2,A3) and each block contain a button.All the three block is based on a same table
Really? Then why did you say this:
nkumar0130 wrote on Mon, 20 January 2014 10:52
In form there are two blocks. each block is based on a table.
If you want any useful help then you need to accurately describe your problem.
How many blocks do you really have?
What is the relationship between them?
What precisely do you want to happen when you press on the button?
At the moment I have no idea what you're trying to do.
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Need help while inserting record in forms [message #606204 is a reply to message #606170] |
Tue, 21 January 2014 03:40 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
As LF says your answer doesn't really help us understand why there are three blocks. What are the differences between the levels?
Because the simplest solution is to have 1 a block instead of 3.
Failing that try the following.
1) Create another datablock as a control block and give it an item empid, the item doesn't need to go on a canvas.
2) In each of the three buttons write code to assign :control.empid to :a<whichever>.empid
3) in the pre-insert trigger of b block assign :b.empid to :control.empid
|
|
|