Showing results for 
Search instead for 
Do you mean 

Using Extension Tables In Application Architect

by on ‎03-03-2011 04:15 AM

I recently finished a POC where we had to show the prospect how we would handle the hundreds of Account related fields they require.  Since all of the fields where not required by every Account type (i.e. Account Subtype A had 50 unique fields, Account Subtype B had 75 unique fields...) I decided to use extension tables. 


If you follow this 2 step process extension tables will work like a charm:

1) In Application Architect use the New Entity wizard.  On the Relationship tab select 1:1 and then select the entity you want to extend (in my POC I wanted to extend the Account entity).

2) When building the data entry form for the extension table make sure to create it under the entity you are trying to extend (e.g. Account) instead of under the extension table (e.g. AcctSubTypeA). 


Note, the one easy mistake to make is to create the data entry form under the extension table (e.g. AcctSubTypeA) in Application Architect.  If you do this, expect to see an error message like, "ACCOUNT" in the web client when trying to save your changes.  The codeless fix is to simply rebuild the form under the entity you are extending (e.g. Account).

by Nickel Contributor
on ‎03-03-2011 04:57 AM

So in this case, would you have created separate tables for the different Account SubTypes where each stored their own values?  Also, would these be tied into field level security in any way, and if so, how is the best way to manage the SECCodeID's in each of the child tables?

by Gold Super Contributor
on ‎03-03-2011 05:14 AM

Good point about the "secondary" SECCODID Jim, AFAIK it's a very well known KI/BUG that it does not get reset tomatch the main/primary table if a territory re-alignment to change owner is done. Definitely is a problem for both Windows/LAN and web.

by Nickel Contributor
on ‎03-07-2011 01:54 PM

That is why I was asking.  I keep running into it and if there are times when the extension tables are being promoted as an alternative, I wondered if there has been something put in place to address the issues we face.

by Gold Super Contributor
on ‎03-07-2011 02:01 PM

Nothing has been done to fix the problem/KI w/SECCODEID in the "secondary table(s) in a 1:1 scenario. It's a problem for Web and Windows/LAN. In a Remote scenario - you end up w/either "missing data" (a data integrity/quality issue) or orphaned records.

Register Read Guidelines Request Partner or Employee Access

What's New in 8.1