Home » Developer & Programmer » Forms » Very confusing doubt about the data block
Very confusing doubt about the data block [message #362228] Mon, 01 December 2008 06:42 Go to next message
Messages: 51
Registered: August 2008

Hi Friends,

I am struck in a situation like this :

I have five tables

1)Segmentation(Master Table)
(ORG_ID(pk), BDID(FK),SDID(FK),Organisation(FK),TDID(FK))

2) Business_Division
(BDID (PK),Business_Division)

3) Sales_Division
(SDID(PK), Sales_Division)

4) Organisation
(ODID (PK), Organisation_Division)

5) Tier
(TDID(PK), Tier_division)

Now i have to create a data block which contains all the columns of the segmentation table and the remaing 4 columns from the other 4 tables, and the values should be displayed correspondingly.

The problem i am facing is that when ever i create a data blcok for segmentation table, and an another block for the buisness_division table, and set a relation between these two blocks, i am getting the values, but there is no vertical scroll bar for the buisness_division block and hence the values are not getting populated correctly(ie, only in the 1st column the values are coming)

And i cannot create a view for these columns beacuse when ever i do an insert or update, only the segmentation table should get updated.

Can any one please help me out with this. This is a very important task assigned to me. Please help me out.

Re: Very confusing doubt about the data block [message #362262 is a reply to message #362228] Mon, 01 December 2008 09:34 Go to previous message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If columns which do not belong to the "segmentation" table are only to be displayed, create them as "display items" and populate them in the POST-QUERY trigger (while fetching data), or in the WHEN-VALIDATE-ITEM trigger while populating values.
Previous Topic: coding in oracle forms
Next Topic: Web Based Application
Goto Forum:

Current Time: Sat Aug 19 17:39:01 CDT 2017

Total time taken to generate the page: 0.01468 seconds