Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index

Using LibreOffice Base v6.4.5.2 on Linux Mint v20.0

Thanks to the assistance given by members of this Mailing List, I have made progress in creating a database using LibreOffice Base.

I have created a database Reactor_Videos which has the fields

(1) Reactor_Videos Table 1
Name (of Reactor)
Location (Country of residence)
Number (of times an artist has been featured)
First (date artist first featured)
Last (Last date artist featured)

and the contents of the spreadsheet I used to record data was copied to the Table Reactors_Video Table 1.

I created a form - Reactor_Videos_Form from that Table - and have used that to enter or update new information. It is quick and I am now getting to grips with creating Queries.

The Table has many Reactors but at present the information relates only to one artist and the only information is the first and last date a particular Reactor reacted to her.

(2) My next step is to have the ability to not only
(a) choose a Reactor

(3) but also to
(b) choose from a list of artists
(c) choose the song the artist is singing
(d) choose the type of venue at which the performance took place

Bearing this in mind, I created three more Tables.

(4) Artist (which has fields)
Date of birth
Country of birth
Country of residence

(5) Songs/Performances (which has fields)

(6) Venue (which has fields)
Concert - indoor
Concert - outdoor
Studio - home
Studio - recording
Private gathering

My first thought was to have the entire database in one Table, differentiating the sectors by using different titles for the ID field, e.g. ID as an Integer (for the Reactor), IDArtist for the artist as an Integer etc. I created the IDArtist as an Integer but when I tried to save it I got the error message. Column constraints are not acceptable in Statement [ALTER TABLE "Table1" ADD "IDArtist" INTEGER NOT NULL IDENTITY] When I click on More I see SQL Status:S1000

Searching on the internet does not help me as it reveals information current about 2015.

I then created Forms from the Tables Artists, Songs/Performances, and Venue with the intention place them on the main form (Reactor_Videos_ Form) and link them, to achieve my objective in (3) above but despite searching the LO Base Manual and watching and listening to tutorials on YouTube, I have been unsuccessful in seeing a way forward.

Any help from members to set me on the right path to achieve what I am attempting will very welcome.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.