Home » Developer & Programmer » Forms » Logic Required to Slove
Logic Required to Slove [message #239865] Wed, 23 May 2007 08:45 Go to next message
siva27
Messages: 34
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 #240053 is a reply to message #239865] Thu, 24 May 2007 00:47 Go to previous messageGo to next message
siva27
Messages: 34
Registered: April 2007
Location: Chennai
Member

Hi all

Can u help me to slove this type of problems
Bit urget

Regards Siva
Re: Logic Required to Slove [message #240066 is a reply to message #239865] Thu, 24 May 2007 01:17 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Do it in master-detail way
Re: Logic Required to Slove [message #240133 is a reply to message #240066] Thu, 24 May 2007 04:06 Go to previous messageGo to next message
siva27
Messages: 34
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 Go to previous message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

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.
Previous Topic: record group Looping
Next Topic: problem in imgscan.ocx
Goto Forum:
  


Current Time: Sat Dec 03 01:00:30 CST 2016

Total time taken to generate the page: 0.10140 seconds