I am using Linux Mint Debian Edition 201403 English 64bit, with LibreOffice 4.1.3.2, and am pretty much a newbie with Linux and LibreOffice.
I use Base to create a new database, then want to create a table using one sheet from an existing .ods file. The sheet contains a column with unique data that I want to use as the primary key. I am unable to create a table using my chosen primary key, I can only create a table with a âdefaultâ primary key of ID which is a number that increments by one for each row in the sheet.
I open the .ods file in Calc, select the sheet I want to use, the sheet has unique column names as the first row, and I Edit-Copy marking all data rows as well as the first row. In Base, I select Tables, Edit, Copy-Paste and get a Copy Table window. I check âDefinition and dataâ, âUse first line as column namesâ and âCreate Primary Keyâ, then in the âNameâ box I type the name of the column containing unique data (rather unimaginatively in this case named âKeyâ). I then click Next. I get a popup saying 'The following fields have already been set as primary keys : Key â and I have to go back. If I do not specify my own column name, the table gets created using ID as the primary key.
Is there a different way I can create a table in Base using a .ods sheet to load the data and the column names, specifying my own primary key ?
Ron