Some SQL tools, like BI or Reporting, can take advantage of knowing more about the relationships between tables.
Will it confuse Aware if I add this type of info?
[MSSQL] Is it ok to use SMSS to add Foreign Keys to the db OUTSIDE of Aware?
[MSSQL] Is it ok to use SMSS to add Foreign Keys to the db OUTSIDE of Aware?
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL
Re: [MSSQL] Is it ok to use SMSS to add Foreign Keys to the db OUTSIDE of Aware?
I have added them with NO problem. Of course, you have to make sure that ALL of the records have a valid parent.
Next time we talk, remind me to tell you about creating views with SchemaBinding and Unique Keys so they can be used in Aware and since they have a primary key, they can be used just like an Aware native BO.
Bruce
Next time we talk, remind me to tell you about creating views with SchemaBinding and Unique Keys so they can be used in Aware and since they have a primary key, they can be used just like an Aware native BO.
Bruce