M
Marian Edu
Guest
well because it isn't 
that order number is seen by the user, client, accountants and IRS so it does have a meaning being the natural primary key on the order table... don't remember much about chemistry so if you like calling it a surrogate as well then by all means go ahead, it will take more than that to confuse me 
On 05/25/2014 06:02 PM, agent_008_nl wrote: From: agent_008_nl Post: RE: composite foreign keys Posted in: OpenEdge Development Link: http://community.progress.com/technicalusers/f/19/p/10162/39045.aspx#39045 And this has nothing to do with the order number thing, that is a natural key while we were talking about surrogates here... so it should not have any meaning Forgot to react on this one. When the ordernumber is system-generated (it mostly is) it can be seen as a surrogate too. Why not, like f.e. in chemistry HSO4 minus can act as acid as well as as basic. -- You were sent this email because you opted to receive email notifications when someone created a new thread. To unsubscribe from: - ...only this thread, disable notifications at http://community.progress.com/technicalusers/f/19/p/10162/39045.aspx#39045. - ...all email notifications from Progress Community, navigate to "Settings", click on the "Email" tab, then under the "Email Configuration" section, set Send Notifications to "No". -- m.edu keep it simple http://www.ganimede.ro http://ro.linkedin.com/in/marianedu medu@ganimede.ro mobile: +40 740 036 212 skype: marian.edu
Continue reading...
that order number is seen by the user, client, accountants and IRS so it does have a meaning being the natural primary key on the order table... don't remember much about chemistry so if you like calling it a surrogate as well then by all means go ahead, it will take more than that to confuse me On 05/25/2014 06:02 PM, agent_008_nl wrote: From: agent_008_nl Post: RE: composite foreign keys Posted in: OpenEdge Development Link: http://community.progress.com/technicalusers/f/19/p/10162/39045.aspx#39045 And this has nothing to do with the order number thing, that is a natural key while we were talking about surrogates here... so it should not have any meaning Forgot to react on this one. When the ordernumber is system-generated (it mostly is) it can be seen as a surrogate too. Why not, like f.e. in chemistry HSO4 minus can act as acid as well as as basic. -- You were sent this email because you opted to receive email notifications when someone created a new thread. To unsubscribe from: - ...only this thread, disable notifications at http://community.progress.com/technicalusers/f/19/p/10162/39045.aspx#39045. - ...all email notifications from Progress Community, navigate to "Settings", click on the "Email" tab, then under the "Email Configuration" section, set Send Notifications to "No". -- m.edu keep it simple http://www.ganimede.ro http://ro.linkedin.com/in/marianedu medu@ganimede.ro mobile: +40 740 036 212 skype: marian.eduContinue reading...