I have just recently started using SAP DB, and am impressed with the range of features available, however I have encountered a problem when establishing referential integrity between primary keys. Basically, I just don't seem to be able to do it. As an Access developer, I find this extremely frustrating.
I have yet to try this just using good old SQL, as I want to be able to do as much as possible through the GUI. Is this a bug in SQL Studio, or am I missing something out? Any help would be greatly appreciated.
Further info: The problem occurs when trying to establish RI between TBL_STUDENTS (PK: Student_ID, Forename, Surname etc), TBL_ENROLMENTS (PK/FK: Student_ID, PK/FK: Course_Code, DateOfEnrolment) and TBL_COURSES (PK: Course_Code, Title, Level etc)
As I say, any help would be greatly appreciated.
Neil Benson
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
