All: RBGeX95(64) 9.5.2.20611
The codes: 'ALTER TABLE TransTest2 ADD FOREIGN KEY (glCodeID) REFERENCES glCode' and 'ALTER TABLE TransTest2 ADD FOREIGN KEY (glCodeID) REFERENCES glCode (glCodeID)' ... elicit the error message: 'The referenced table does not exist (2801)' The referenced table and columns most certainly do exist, all data types match. ?? All thanks, Bruce --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================

