12-18-2011 05:47 PM
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!
12-19-2011 07:28 AM
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).