LibreOffice Base - Video Game Database (Easy)

This is a simple video game database designed in LibreOffice Base. I have done this for one of my subscribers who requested some assistance and thought that maybe other people would like to know about this as well.

[shanepiper]

Because the ConditionID is a unique value and its better to source information from a unique value rather than a field that can have a variation of the same condition. eg misspelt words. The ConditionID is set as a primary key and to auto increment. I find its better to reference a condition from a conditionID than just the condition itself.

[mendroy]

Excellent video and easy to do, i made it for a data base in water services, thanks!!

[EdOscuro]

You'll be happy to know that when I searched Google for 'libreoffice base collection' this is the first youtube link - and it looked more relevant to what I'm trying to do than the other hits.

[totaltotalmonkey]

Thanks for the answer, that makes sense. I've been looking at the macro feature of LibreOffice, its tricky but I'm getting there slowly.

[denisayolie]

This is what i have been looking for the past 5 weeks , Thank you, that is great!

[vvurx]

thank you. great tutorial. i study comptuter science and i want to learn how databases work

[totaltotalmonkey]

Thanks for the video. For the condition table, why do you use 'condition ID' and 'condition'. You could just use 'condition' as the primary key and it would work just as well for the list box.

[LudwigSpiegel]

Nice! I do use Linux too.Great tutorial.

[Noiee]

Really like this video, helped me a lot. But do you know how to make a field with this kind of drop-down list but also the possibility to add a new record to the table the list is related to, preferably by just typing in the field (so having the list but also the option to type in the field and add to the list) ?

[Cameron]

Thanks to your Libre Office Base videos, I have redesigned my DB to include a subform and so far is working nicely. One issue i am facing is getting my tab to shift from the main form to the subform. I setup the tab under Tools/Customise/Keyboard to use Shift+F3 to move to the subform. Shift+F4 moves back to the mainform, but it doesn`t work. I even tried the setup in edit mode. Any suggestions would be greatly appreciated. P.S. tab order in each form works perfectly

[AwesomeAxolotlt]

thx, I was looking for somthing like this

[SonicZoom]

For some reason every time I exit design mode with my image set, it disappears. Everything is enabled. I just have no clue what's going on.

[tarik]

Hi, first thx for the vid. I just wanted to know my version wish I just downloaded does not have the command "replace with"that u used in the forms to pics and also does not have general under control it's wierd
Thx again

[firozfibi]

Will the image place holder be there if I export in to PDF?