Hello David, could you post (to the list) 1. definitions of the referenced tables 2. a description of what exactly you tried to do to create table 'WORK_ON_CD' with the FKs on it. 3. the username under which you tried to get this to work in SQL Studio 4. the versions of the database and of your SQL Studio installation
regards, Markus Stausberg SAP Labs Berlin > -----Original Message----- > From: David Sills [mailto:[EMAIL PROTECTED] > Sent: Monday, March 03, 2003 3:54 AM > To: [EMAIL PROTECTED] > Subject: Question about foreign keys > > > 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 > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
