Hello Dany, > I was trying to create a foreign key in a table that references its own > primary key. The UI for Relationships does not seem to allow this. Is > this feature supported at the moment? If not, is there a workaround? or > will it be supported in the future?
No. Yes. Perhaps. The workaround would be issueing the SQL command directly, e.g. using the Tools/SQL dialog. Needs some SQL knowledge, admittedly, and might depend on the concrete database engine you use. For the "perhaps", I suggest you submit an issue requesting this support (AFAIK, there is none so far). Shouldn't be too difficult to implement, at least I cannot really imagine a reason why this limitation is in place (but the code for this UI is from stone-age, so there might have been some reason ...) Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
