Eric, At the moment you seem to be so busy kicking the car because it has a stick shift and you think all cars should be automatic that you forget you can get from A to B in both. From your posts today it's apparent that you are rather familiar with SQL Server, much less so with R:Base and very frustrated. Whether R:Base is "better" or "worse" is irrelevant - if you have to work with it, you have to work with it as it is.
You say that it's ridiculous that, if you use the same name - which is rarely unavoidable - for two unrelated columns in two unrelated tables, they should not relate automatically. How is the database to know when you want it related and when you want it unrelated? You either have to be able tell it to relate the columns when you want them related or let it assume that they are - I don't think there's another possibility. Both approaches are valid and, if you prefer the first, that's fine but R:Base does it the second way. You say you want to delete the "bad" table and recreate it the way you think it should be. Unless it is empty, you may be looking to make this harder than necessary: you could do as Bill and Sami told you and then use either the Designer in the Object Manager or the ALTER command from the R:> to change names, datatypes and column widths as you fancy (watch out for computed columns). You can change the column order, if you want, by PROJECTing a new table in the order you want. You then blitz the first table and rename the new table to the name of its parent. All the forms and reports will still be there for you although you may have to fix them up a bit if you have added, deleted or resized columns. I think you will have a happier outcome to your project if you put aside the very bias you accused someone else of and take R:Base on its own terms. Nicky ================================================ 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
