Creating Joins

Joins in Siebel is the thing that makes the relationships between tables possible. The difference between Join and the some other relationship method (like in Access making a simple relationships between tables) is that the relationships is based on Business Components in Siebel Business Layer not on the Tables them self.

1) So first of all you need two Business Components between who we will make relationship;
2) In Child Business Component create Field that you will see on Applet with data from Parent Business Component;
3) Then in Child Business Component create Field that will store ROW_ID from Parent Business Component. This Field must be based on column of Child Business Component based Table;
4) Then in Child Business Component create Join that is based on Table on which is based Parent Business Component;
5) Then for newly created Join add Join Specification with column from Parent Business Component Table that store ROW_ID (usually it is ROW_ID) and Source Field is Field we created in point 3. (Field that stores the Parent Business Component Table ROW_ID;
6)Then modify Field we created in point 2. by adding Join property of Join we created in point 4. and adding a column from Join (from Parent Business Component Table) that you want to see on applet (for example NAME)

Example - You have applet with Contacts and you want to see on it Account the Contact belongs. Account is Parent Business Component and Contact is Child Business Component. So you create two new Fields on Contacts Business Component, one Join also on Contacts Business Component. In the end if you will put on applet Field we created in step 1. you will see a Account Name, but in the Data Base will be ROW_ID of the record in Accounts Table.

About my last post about Check In/Check Out, there is some problems with this. I will update it as soon as I test everything.