Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Tuned Listener
Posts: 67
Registered: ‎11-29-2011

Change Relationship

Hi,

 

Is it possible to change the relationship of an existing structure? I have two tables which is 1:M relationship at the moment. I want to change it to 1:1 now, but I don't want to delete the existing table Can I do it in SalesLogix Application Architect?

 

Thanks a lot for all the help!

Highlighted
Bronze Super Contributor
Posts: 129
Registered: ‎06-09-2009

Re: Change Relationship

Going from a One to Many to a One to One relationship "logically" shouldn't require you to drop and re-add the table, but if you don't you probably will run into issues.

 

On a 1:1 relationship, both tables contain the Same Unique Key. However, on a 1:M relationship, the Many table has its own Unique Key and a Foreign Key for the Parent table.

 

That said, within App Arthicte you could change the "Relationship", which changes the Code generated for the Entities, but won't change the Schema (and may actually cause problems).

 

My advice would be to recreate the table(s).

Raul A. Chavez
http://raul.chavez.com
http://www.crmbi.com