LibreOffice-Suite-Base/C2/Add-List-Box-form-control-to-a-form/English-timed
From Script | Spoken-Tutorial
| Visual Cues | Narration | |
|---|---|---|
| 00:03 | Welcome to the Spoken tutorial on LibreOffice Base. | |
| 00:06 | In this tutorial, we will learn how to Add a List Box form control to a form | |
| 00:14 | In the last tutorial, we learnt how to modify a form using LibreOffice Base. | |
| 00:20 | We also saw this image of the form that we started creating and modifying in the last tutorial. | |
| 00:34 | And once we are done with our design, this is how our form will look like. | |
| 00:45 | Notice here, that we are seeing the first record in the Books Issued Table. | |
| 00:52 | And, we are also seeing list boxes with real book titles and member names, instead of book Ids and member Ids. | |
| 01:01 | Here are some push buttons at the bottom for performing actions like saving a record, undoing the changes etc. | |
| 01:11 | So in this tutorial, we will learn how to add a List box form control to our form. | |
| 01:20 | Let us first invoke the LibreOffice Base program, if it's not already open | |
| 01:32 | And open our Library database. | |
| 01:35 | If Base is already open, then we can open the Library database from here by clicking Open under the File menu | |
| 01:45 | or by clicking the Recent Documents under the File menu | |
| 01:50 | Now we are in the Library database. | |
| 01:54 | Let us open 'Books Issued to Members' form that we created in the last tutorial. | |
| 02:01 | To do this, let us click on the Forms icon on the left panel | |
| 02:07 | And right click on the 'Books Issued to Members' form on the right panel, and then click on edit. | |
| 02:17 | We are now in the form design window. | |
| 02:21 | Let us first consider the 'Book Title' label. | |
| 02:25 | Notice that the text box here will only display BookId numbers which are not friendly on our eyes. | |
| 02:33 | For us, book titles are friendlier. | |
| 02:37 | And so, to display these titles, Base provides some ways, and one of the ways is by using a List box form control. | |
| 02:48 | Let us see how. | |
| 02:51 | For this, let us first remove the text box adjacent to the Book Title label. | |
| 02:59 | We can do this by clicking on the text box which selects it with the familiar set of green boxes, | |
| 03:09 | And then by right clicking and clicking on 'Cut' at the bottom. | |
| 03:16 | There, we have removed the text box. | |
| 03:20 | Now, we will place a List box form control here. | |
| 03:26 | This can be accessed in the Form Controls toolbar. | |
| 03:31 | We can bring it up by using the View menu and clicking on the Form Controls. | |
| 03:39 | Notice that Base provides us a lot of form controls; let us point our cursor over these icons to read the tool tips. | |
| 04:01 | Let us find our list box icon. | |
| 04:04 | There it is, let us click just once on this icon. | |
| 04:11 | And let us move the mouse pointer into the form; notice that it has changed to a thin plus symbol. | |
| 04:21 | Now we can draw the list box form control on our form; | |
| 04:26 | For this, we will simply click, drag and drop it on our form | |
| 04:34 | Let us place it where we removed the text box earlier. | |
| 04:39 | Notice that a new wizard called 'List Box Wizard' has opened up over the Form design window. | |
| 04:48 | Now, this wizard will help us connect the list box to the Book title label. | |
| 04:56 | Let us see how. | |
| 04:58 | In this wizard, let us first, choose the table from where we can get the book titles. | |
| 05:07 | We will choose the Books table from the list and click on the Next button. | |
| 05:15 | Now, in this window, we need to choose the field that will be displayed in the List box. | |
| 05:24 | And we know that the title field stores the book titles. | |
| 05:29 | So let us go to the next step. | |
| 05:32 | This final window is where we will do the magic. | |
| 05:37 | We will connect the related tables and fields. | |
| 05:41 | Look at the field names. The 'Fields in the Value table' on the left are the fields in the Books Issued table | |
| 05:52 | And the 'Fields in the list table' on the right are the fields in the Books table. | |
| 05:59 | We also know that book id is the key field in the books table and is represented in the Books Issued table. | |
| 06:10 | So we will click on book id on the left side list that says 'Field from the value table'. | |
| 06:19 | Next we will click on book id on the right side list that says 'Field from the list table'. | |
| 06:29 | Click on the Finish button to close this wizard. | |
| 06:34 | There, we have connected the related tables and fields. | |
| 06:40 | Now Base will automatically display all the Book titles in this List box. | |
| 06:46 | Let us now save the form. | |
| 06:49 | And close this window. | |
| 06:52 | In the next part of the Base tutorial, we will continue adding the rest of the form controls to our form. | |
| 07:00 | And this is how our form will look like, when we are done. | |
| 07:06 | Here is an assignment. | |
| 07:08 | Add a second list box for listing member names instead of unfriendly member Ids. | |
| 07:17 | Do not worry about the placement of the list box now. Just draw it to the left of the Member name label. | |
| 07:27 | We will relocate it appropriately across the Member Name label in our next tutorial. | |
| 07:34 | This brings us to the end of this tutorial on List Box Control in LibreOffice Base | |
| 07:40 | To summarize, we learned how to: Add a List Box form control to a form. | |
| 07:47 | 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. | |
| 07:58 | This project is co-ordinated by http://spoken-tutorial.org. | |
| 08:04 | More information on the same is available at the following link. | |
| 08:08 | This script has been contributed by Priya Suresh, DesiCrew solutions.
And this is Soundharya, DesiCrew solutions, signing off. Thanks for joining
|
