Eric - Let's call your tables 'GoodTable' and 'BadTable' and call the linking column 'LinkingCol'.
If you go to the R> and type: LIST COL LinkingCol Is it listed as a Foreign key? If not, just type: RENAME COL LinkingCol TO UnlinkingCol If so, type: List Constr and look for the ID number of the Foreign Key constraint. (Let's say it was #65) Type: ALTER TABLE BadTable DROP CONSTRAINT #65 You can also do these commands using the R:BASE menus, but without knowing what version you are working in, I couldn't give you the proper method. These commands should work in just about any version of R:BASE. Regarding your comment that you think it's ridiculous that R:BASE identifies same-column names as related - I disagree wholeheartedly. I think it's one of the major plusses of R:BASE over some other databases. And R:BASE doesn't automatically make one a foreign key - someone had to intentionally set that up. All R:BASE does is recognize that the fields are related in multi-table forms and in linking views using the Windows Query screens. Sami Aaron Software Management Specialists 13214 W. 62nd Terr, #139 Shawnee KS 66216 913-915-1971 http://www.softwaremgmt.com ----- Original Message ----- From: "Eric Peterson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 06, 2001 9:19 AM Subject: Duplicate Column Names = Foreign Key... UGH > > I have two completely unrelated tables; one of which is not used. > Whoever created this second table mistakenly named a column matching a > column name in the first table. Rbase makes this a foreign key (which I > think is rediculous). > > I want to drop the second table, and recreate it with proper column > names, etc. How do I do this being that Rbase things I have a > relationship to the first table? > > Eric > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > > > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l
