Le mercredi 4 avril 2007 22:MM, Ron Horsley a écrit : Hi Ron,
> Another correspondent raised 'Primary Key' which was new to me is this > relevant to what has now been said above? A primary key is a uniquely identified field in which no single item of data is repeated throughout the whole of the table. In other words, it uniquely identifies each row of a given table. I seem to recall that this terminology also exists in Lotus Approach (although it's been nearly 8 years since I last used Approach). This usually takes the form of an incremented series of numbers, although there are other possibilities, such as a unique string of characters, or a combination of fields. If you want to be able to edit a table in OOo Base, your table needs to have a primary key field. If, when you created your database document, you simply referenced the spreadsheet, it will not be editable. If however, you open the spreadsheet document in Calc, then select the sheet with the data on it and drag it to your open ODB document, a little wizard (or assistant) should start and offer you the chance to adapt the field definitions, but also add a primary key for you automatically. Once this operation has been done (it may take a while if you have a lot of data in your spreadsheet, you should thereafter be able to edit the data directly as an integrated table in the database document. Bear in mind that if you do this, your original spreadsheet is no longer the reference, and is consequently not updated, but the data within the database will be. If you then want to extract and print data from your table to a spreadsheet format, you can run a query and then drag and drop the results of that query into a spreadsheet table for formatting. It is also possible to make a dynamic link between the spreadsheet and the query so that when you update data in your database, the corresponding spreadsheet will also be updated. There should be documentation (other than the built-in help) available on the web that explains this (the OOo documentation project User Guide or OOoAuthors web site). Alex --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
