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
SUHAS22845
Messages: 51
Registered: August 2008
Location: BANGALORE
Member

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
Littlefoot
Messages: 20891
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: ATT colum
Next Topic: what is propery class
Goto Forum:
  


Current Time: Sun Dec 04 16:35:04 CST 2016

Total time taken to generate the page: 0.24040 seconds