| Very confusing doubt about the data block [message #362228] |
Mon, 01 December 2008 06:42  |
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  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
