slxdeveloper.com Community Forums

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!

Web Forums - SalesLogix Web Platform & Application Architect
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Web Platform & Application Architect | New Thread

View: Search:

Author

Thread: Change the binding field of an extension entity

Ken Poggensee
Posts: 71

Change the binding field of an extension entity Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 Nov 08 12:41 PM

Hi Gents…

Is there a way to override the binding fields on an extension table.

Here is my situation:
Opportunities 1:N to Quotes
Quotes 1:N to Quote_Products
Quote_Products 1:1 to Products

I have a main view showing my quote detail. I have a tab that is suppose to show the Quote_Products data along with some Product data. This data is not showing up because the join the system uses is Quote_Products.Quote_ProductsID=Product.ProductID when it should be Quote_Products.ProductID=Product.ProductID. I found this out through SQL Profiler…

I have the Quote_Products entity as an extension from the Products entity.

I looked all over for a place to change the binding fields and couldn’t find anything. I even tried to remove the extension property and create a child relationship instead of an extension. That way I could assign the productid to productid but it puked all over itself during the build.

Any advice on how to tell the extension binding I want it to use as the binding field. Or am I going down then wrong path there???

As always, you guys ROCK and I appreciate any pointers…

--Ken

[Reply][Quote]

Alberto Chiesa
Posts: 49

Re: Change the binding field of an extension entity Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Nov 08 2:57 AM

I don't know of any way to change the beaviour you describe.

The question is: why are you setting up Quote_Products as an extension of products?

(One quote has many products, but a product has only one quote???) Shouldn't be N-N between quotes and products?

[Reply][Quote]

Ken Poggensee
Posts: 71

Re: Change the binding field of an extension entity Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Nov 08 10:10 AM

It’s the same relationship as Opportunity_Products to Products. An Opportunity can have many Products. An Opportunity_Product record can only have one Product.

I have an Opportunity that can have many Quotes. Each Quote can have many Quote_Products. For every Quote_Product record I can only have one Product.

Actually with that being said, I am looking that the relationships for OpportunityProducts in AA and see that it has both Opportunity and Products defined as parents. I’m going to mirror that and see what happens.

I will post back my results…

[Reply][Quote]

Alberto Chiesa
Posts: 49

Re: Change the binding field of an extension entity Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Nov 08 10:16 AM

Quote:

Originally posted by Ken Poggensee

I have an Opportunity that can have many Quotes. Each Quote can have many Quote_Products. For every Quote_Product record I can only have one Product.

Yep. But each Product can have many Quote_Products. In your configuration a single product can be associated to a single Quote_Product.

Hence, a single Product can be associated to a single Quote, which probably is not what you want.

You have to setup OpportunityQuote with 2 1-n relationships, which mimiks a n-to-n relationship.

[Reply][Quote]

Ken Poggensee
Posts: 71

Re: Change the binding field of an extension entity Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Nov 08 12:13 PM

Thanks Alberto. You hit the nail right on the head.

I set up my Quote_Products as a child to both Quotes and Products and all is good in the world again.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 8/16/2025 7:39:18 PM