Use Database to keep adding updates to a record

[SimonButt]

I currently use a spreadsheet to keep a record of progress in tasks. This means the number of columns keeps increasing as the periodic updates need to be kept. I assume a database would be better for this and then I could pull up the records and have all the updates or just the latest ones based on date. I could also pull up a table of all the tasks etc.
The spreadsheet columns would be like this;
Task, Description, required by, completed date, completed comment, update 1 date, update 1 comment, update 2 date, update 2 comment,…, update 199 date, update 199 comment, etc as the updates are added.

Ideally I’d like to have an entry form where I can select the task and add the update by date and the comment. Then be able to call up the record as all updates or just the most recent or export all the tasks to a table / spread sheet if required.

If this is possible I am struggling to come up with the correct terms to google to find out how to do it. If anyone could either tell me it’s not possible or point me in the right direction that would be very helpful.

[Wanderer]

I’d suggest to have a look at the handbook for Base. It contains several examples so you can adapt to the language and may even find somthing to be used as a starter.

[SimonButt]

Thanks that is really useful, a good point in the right direction. I did a google search for the handbook you mentioned and found documentation that I hadn’t found before.

For anyone else, there are great docs for LibreOffice here
https://documentation.libreoffice.org/en/english-documentation/

[Villeroy]

This is a one-to-many relation. You need a table of tasks and another table with updates including a foreign key to the tasks.
See [Example] Relations reflected by list boxes in forms (the relation between persons and animals).

[SimonButt]

Thanks, that’s really useful. When one doesn’t know what know what something is called it can be impossible to search for it. I’ve got good material to work with now