Difference between revisions of "LibreOffice-Suite-Base/C2/Add-List-Box-form-control-to-a-form/English-timed"

!Narration

||Welcome to the Spoken tutorial on LibreOffice Base.

||In this tutorial, we will learn how to Add a List Box form control to a form

||In the last tutorial, we learnt how to modify a form using LibreOffice Base.  

||And once we are done with our design, this is how our form will look like.  

||Notice here, that we are seeing the first record in the Books Issued Table.  

||And, we are also seeing list boxes with real book titles and member names, instead of book Ids and member Ids.  

||Here are some push buttons at the bottom for performing actions like saving a record, undoing the changes etc.

||So in this tutorial, we will learn how to add a List box form control to our form.

||Let us first invoke the LibreOffice Base program, if it's not already open

||And open our Library database.

||If Base is already open, then we can open the Library database from here by clicking Open under the File menu

||or by clicking the Recent Documents under the File menu

||Now we are in the Library database.  

||Let us open 'Books Issued to Members' form that we created in the last tutorial.  

||To do this, let us click on the Forms icon on the left panel  

||And right click on the 'Books Issued to Members' form on the right panel, and then click on edit.

||We are now in the form design window.

||Notice that the text box here will only display BookId numbers which are not friendly on our eyes.

||And so, to display these titles, Base provides some ways, and one of the ways is by using a List box form control.  

||For this, let us first remove the text box adjacent to the Book Title label.  

||We can do this by clicking on the text box which selects it with the familiar set of green boxes,

||And then by right clicking and clicking on 'Cut' at the bottom.  

||There, we have removed the text box.  

||Now, we will place a List box form control here.  

||This can be accessed in the Form Controls toolbar.  

||We can bring it up by using the View menu and clicking on the Form Controls.

||Notice that Base provides us a lot of form controls; let us point our cursor over these icons to read the tool tips.  

||And let us move the mouse pointer into the form; notice that it has changed to a thin plus symbol.  

||Now we can draw the list box form control on our form;

||For this, we will simply click, drag and drop it on our form

||Let us place it where we removed the text box earlier.  

||Notice that a new wizard called 'List Box Wizard' has opened up over the Form design window.  

||Now, this wizard will help us connect the list box to the Book title label.  

||In this wizard, let us first, choose the table from where we can get the book titles.  

||We will choose the Books table from the list and click on the Next button.  

||Now, in this window, we need to choose the field that will be displayed in the List box.  

||And we know that the title field stores the book titles.  

||So let us go to the next step.

||We will connect the related tables and fields.  

||Look at the field names. The 'Fields in the Value table' on the left are the fields in the Books Issued table  

||And the 'Fields in the list table' on the right are the fields in the Books table.  

||We also know that book id is the key field in the books table and is represented in the Books Issued table.  

||So we will click on book id on the left side list that says 'Field from the value table'.  

||Next we will click on book id on the right side list that says 'Field from the list table'.  

||Click on the Finish button to close this wizard.  

||Now Base will automatically display all the Book titles in this List box.  

||Let us now save the form.

||And close this window.

||In the next part of the Base tutorial, we will continue adding the rest of the form controls to our form.  

||And this is how our form will look like, when we are done.

||Add a second list box for listing member names instead of unfriendly member Ids.

||Do not worry about the placement of the list box now. Just draw it to the left of the Member name label.

||We will relocate it appropriately across the Member Name label in our next tutorial.

||This brings us to the end of this tutorial on List Box Control in LibreOffice Base  

||To summarize, we learned how to: Add a List Box form control to a form.

||Spoken Tutorial Project is a part of the Talk to a Teacher project, supported by the National Mission on Education through ICT, MHRD, Government of India.  

||This project is co-ordinated by http://spoken-tutorial.org.  

||This script has been contributed by Priya Suresh, DesiCrew solutions.