The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Grid Not Showing recods - INNER JOIN
Posted: 10 Oct 08 9:06 AM
|
Hello, im running with a little problem here.
I have a form with a grid based on AccountProduct Entity
I need to show records from AccountProduct and Account ProductX that is One-2-One with AccountProduct.
I created the new AccountProductX entity and set the Option "Is Extension" to AccountProduct. By doing this i cant create any relationship between this tables.
Now, the fact is that AccountProductX is empty so the grid isn't showing anything because of that. Is like is doing an INNER JOIN.
Is there a way to solve this?
Thanks
John. |
|
|
| |
|
Re: Grid Not Showing recods - INNER JOIN
Posted: 15 Oct 08 9:19 AM
|
| I think what you're running into has to do with the fact that the record in the AccountProductX table is not getting created when you create the record in Account Product. If these are created in the process of closing an oppty, it may be a little more difficult to deal with. If they are manually adding these records, you could try what I've done in the past with 1to1 tables tied to account or contact Basically we forced the creation of a record by placing a required field and default value from the table on the main objects screen. |
|
|
|
Re: Grid Not Showing recods - INNER JOIN
Posted: 15 Oct 08 9:19 AM
|
| I think what you're running into has to do with the fact that the record in the AccountProductX table is not getting created when you create the record in Account Product. If these are created in the process of closing an oppty, it may be a little more difficult to deal with. If they are manually adding these records, you could try what I've done in the past with 1to1 tables tied to account or contact Basically we forced the creation of a record by placing a required field and default value from the table on the main objects screen. |
|
|
| |
| |
|