I am completely new to Base, so this question might sound a bit strange or confusing… picture below.
So, I need to create a form to populate the Costs table. However, to make it easier, I would like to “provide” the ProjectID not by entering its value, but choosing the corresponding ProjectName from a drop-down list, which contains only the Projects records where the ProjectStatus is “Active”.
How do I do that? Also, where can I learn more about this topic, or Base in general?
db.odb (4.7 KB)
Start at LibreOffice.org, find the menu, try “Get Help” > “Documentation”
There is a guide for Base.
.
You create a listbox, then connect this to a SELECT statement wich has your needed data ID and NAME. The “bound field” tells wich item is written in your form, while showing the Name.
.
For first steps I recommend videos, so for this topic and english language you may try this (thefrugalcomputerguy / video 49):
… and first: Set “CostsID” and “ProjectID” to . Fill “Projects” with some content.
Special for testing and starting this chapter of Base Guide might be usefull:
https://books.libreoffice.org/en/BG73/BG7301-IntroductionToBase.html#toc24