On 1/31/06, Andrew Jensen <[EMAIL PROTECTED]> wrote: .. > Instead of the unique constraint, you could have created a unique index > from the table defnition editor on columns > c.one and c.four this will still keep you from adding the last entry in > your example. A unique constraint I believe, > should not be the same as a unique index - yet under Base it shows up as > one. I can't tell you for sure whether > creating a unique constraint therefore actually generates the index or not. > There is one difference under base, > add a unique index via the GUI and you can drop it. Add it via the ALTER > TABLE ADD command and you may > not. It is listed as a system index, you must again use DDL to drop it. I > would use the ALTER TABLE ADD > command myself, and add the index only later, if needed. > > Finally, if you tried to apply the two foreign key relationships in the > Relationship dialog under Base you would not be able to, > this is a known issue. However, once you have added them via the DDL > commands, opening the Relationship dialog will > show both. (you will need to close and open the Base file, before they will > show up in this dialog???) > > HTH > > Drew ..
First, thanks for the prompt reply! I'm carefully reading your e-mail and it looks very helpful. It's good to know that at least it's possible and that it must be done with SQL--I was going a bit batty. thanks, Thufir --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
