this is a question related to Siebel
I am trying to query a field in Parent BC from a Child BC. The thing is, I am not sure which field in the child BC is connected to the parent BC. I have checked the Link between these BC, there is no value in source field and destination field. However, there is an intertable and there are values in the inter child and parent column.
Do I need to use the value there as the connection ? If no, where else should I check for the connected field ?
Thank you.
If inter-table link is being used then that means it is a M:M relationship. One trick is to create a new BusComp based on the inter-table. You can then use the identifier from Child BusComp and query in the inter-table BusComp to get the record. That record will have the identifier of Parent BusComp as well.
This way you have a method to traverse from Child BusComp record to Parent BusComp record.