To whom it may concern: This is my first attempt at using this listserv, so forgive any errors in execution.
I'm trying to establish a referential integrity constraint between two tables in a recently-created database in SAP DB 7.4 on Windows XP Professional. I'm using the Database Manager GUI. This appears, from the description in the SAP DB library and downloaded PDF, to be very simple. However, I can't get it to work at all; my implementations are simply ignored. I have a CAT database with a mapping table: CREATE TABLE WORK_ON_CD ( ID Integer, CD_ID Integer, WORK_ON_ID Integer PRIMARY KEY(ID) FOREIGN KEY FK_1 CD_ID references CD FOREIGN KEY FK_2 WORK_ID reference WORK ) Both foreign keys reference ID columns in the referenced tables, which is pretty ordinary. How can I get this to work? I've tried to D&D the tables, but the primary key columns are not there to be selected. And it ignores me if they're not there. Thanks for any help. David Sills __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
