Hi,
Why there are no FK relationships among tables in the RMS DB?
For example Item table has a DepartmentId field that does refer to Department table.
Thank,
Ignacio
*This post is locked for comments
I think this is just a growing pain of coming from Access to SQL Server. Just something that never got changed. To change it now could be fairly catastrophic for the hundreds of add-ins that have been created since that point.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156