Mr. Cheese a écrit : Hi Mr Cheese, (said Jacob to his Cracker), > Help. I'm confused. I have a number of applications that I developed > using Lotus Approach (DBase files) I want to use some of these to play > with OO Base. I cannot create relationship links until I designate key > fields. I follow the help instructions but don't see how to designate > existing fields as "key" fields. > What am I missing? > Help screens only show how to do this when creating a DB from scratch.
You can not create relations between separate DBF files, that is an unfortunate limitation of the current Base module implementation. Indeed, one might hope that IBM, now member of the OOo project, would be generous enough to provide the same wrapper code as Lotus did for Approach in order to achieve this, although that might depend rather a lot on who owns the rights to the original code :-) For the moment, the only way to create relations between 2 or more DBF files in the OOo Base module is to either use an ODBC driver (Windows only I'm afraid) to do so, or to import each DBF file as a table in a native HSQL database (i.e. the built in database backend engine in the OOo Base module). Generally, you can do this by creating an ODB file for each DBF file you have, then creating a new HSQL-ODB document, you copy/paste your DBF table into your HSQL-ODB document, at the same time creating an automatic primary key. Alex --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
