| Logic Required to Slove [message #239865] |
Wed, 23 May 2007 08:45  |
siva27
Messages: 41
Registered: April 2007
Location: Chennai
|
Member |
|
|
Hi All,
Layout Style
I have a Form with 2 frames.And i have one table which consists of 10 Columns.In ist Frame i'm using 4 columns and Layout Style as Form.
the remaing 6columns i have used seperate frame with Layout Style as Tabular Form.
But my requirement is that for 1st time i will insert the data and it will store.
If i query i will get the exsisting data from database.
Again i want to insert new record in 2nd Tabular Frame,But 1st frame data sholud be the same.And even i should have have any right to update the exsisting records.
Again if i query i will get 2records in the Tabular Frame,if again insert 3rd record it has to insert by keep the 1st Frame data as it is ?
This is how i need please any one can help me to come out of this problem.
If u have any sample code for that u can pls forward.I will be thankful to u all.
Regards
Siva
|
|
|
|
|
|
|
|
| Re: Logic Required to Slove [message #240133 is a reply to message #240066] |
Thu, 24 May 2007 04:06  |
siva27
Messages: 41
Registered: April 2007
Location: Chennai
|
Member |
|
|
Hi thanks for ur reply,
But my client have given me 1table.Master-Details it will work as u said.
This is how the senario required for me.If u have any idea on this can u pls send me the code ,as it is bit urget.
Regards
Siva
|
|
|
|
| Re: Logic Required to Slove [message #240160 is a reply to message #239865] |
Thu, 24 May 2007 04:54 |
|
|
|
No problem having only 1 table, you can still do master-details relationship. For the master, use block from query. The query should be distinct of that 4 columns. The details block will be a regular block. Now do the trick on "ON-insert" trigger of the master. do not insert on master, but just add those data to the data you are inserting on details to complete the 10 columns. same thing on update.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
