[MSSQL] Is it ok to use SMSS to add Foreign Keys to the db OUTSIDE of Aware?

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

[MSSQL] Is it ok to use SMSS to add Foreign Keys to the db OUTSIDE of Aware?

Post by Jaymer »

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?
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
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: [MSSQL] Is it ok to use SMSS to add Foreign Keys to the db OUTSIDE of Aware?

Post by BLOMASKY »

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
Post Reply