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!
|
|
custom table not showing
Posted: 17 Apr 08 1:27 PM
|
We are attempting to add a field from a custom 1:1 table on the opp detail web form, but that table isn't showing anywhere. How can I get it added to the relationships or child?
thanks,
dave |
|
|
|
Re: custom table not showing
Posted: 17 Apr 08 1:56 PM
|
I assume you are talking about not seeing it in the AA, right?
You need to bring the table into the entity model before you can see it. Right click on the package in the Entity Model (the SalesLogix Application Entities) and select New Entity. Then step through the wizard to create a new entity based on your table. Make sure you select a 1:1 relationship to the Opp entity so it gets created as an extension.
-Ryan |
|
|
|
Re: custom table not showing
Posted: 17 Apr 08 2:48 PM
|
You are correct about that in AA.
I have added the entity and can see it under the Child Properties of Opportunity. It is set to a M:1 Cardinality under Opp. It is just when I try to modify the OpportunityDetail form, that when I right click - Insert - Property, it isn't showing in that list.
thanks,
dave |
|
|
| |
|
Re: custom table not showing
Posted: 17 Apr 08 2:57 PM
|
That is correct, just a 1:1 table. It is just when I created the entity, it didn't have an option for a 1:1, which I thought was strange. Just options for 1:M and M:1.
Basically, I have an OppAddOn table that is 1:1 w/ Opp. I can see OppAddOn under the Opportunity - child Property. It looks pretty much identical to Reseller or Leadsource.
a real head scratcher for me.
thanks,
dave
|
|
|
|
Re: custom table not showing
Posted: 17 Apr 08 3:09 PM
|
For relationships that is true, only 1:M and M:1. For an extension table (1:1) you don't create a relationship - you just flag it as an extension and select it's parent.
Delete your entity. Then rebuild everything.
Then bring in your entity again. When your entity is in AA, open it and check the box for "Is Extension". Then a drop down will appear where you can select Opportunity. Then rebuild again.
-Ryan |
|
|
|
Re: custom table not showing
Posted: 17 Apr 08 5:12 PM
|
you are THE MAN. thanks Ryan. I forgot that I had to build once I added that. Duh!
Now when I deploy, I'm getting a "unable to find the IIS server..." error. It's been a day!
thanks
dave |
|
|
|