OraFAQ Forum: Forms » oracle forms

Home » Developer & Programmer » Forms » oracle forms (oracle forms6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle forms [message #511544]

Mon, 13 June 2011 15:23

fordhenry99
Messages: 1
Registered: June 2011

Junior Member

Hi,

I have create two blocks based on one table.first block is in content canvas in header and second block is in lines in tabpages.
now i enter data for header and lines.Here header record is going to one line in a table and line record is going to other line in a table.This should be saved in one line in a table.where header records are saved in next columns lines should be there.any suggestion on this?

ex:-
headers-reqtype,status,preparer
lines-item,qty,UOM
records should be saved in the following
table:
reqtype status preparer item qty UOM
PURCHASE INCOMPLETE XYZ adhfk 10 EA
PURCHASE INCOMPLETE USD ajhds 15 EA
PURCHASE INCOMPLETE SDH kjsdh 16 EA

Report message to a moderator

Re: oracle forms [message #511547 is a reply to message #511544]

Mon, 13 June 2011 15:28

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It seems that your data model is not normalized; otherwise, you wouldn't have such a question.

Normalize the model and your "problem" will disappear.

Report message to a moderator

Re: oracle forms [message #511548 is a reply to message #511544]

Mon, 13 June 2011 15:35

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

You and your buddy rajendaroracle with the same IP address have the same question (and with the same inadequate title no less). Same bad design from two people at the same place.

[Updated on: Mon, 13 June 2011 15:37]

Report message to a moderator

Previous Topic:	How to fetch records when tab page changes?
Next Topic:	COMMIT_FORM and DO_KEY('COMMIT_FORM') difference

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 12 09:03:32 CDT 2024