Screen cast: AppGini lookup fields and master detail pages
In this screen-cast, we'll add a "category" look-up field to books, and show how to display all the books that belong to a selected category.
00:07 Look-up fields are drop-downs listing data from another table, which help you organize your web application.
00:15 This is how our final table looks like.
00:23 Click any entry. Do you see how the category field is displayed? It gets its data from the "Categories" table.
00:42 Let's switch to AppGini to see how to set a field as a look-up field.
00:54 First, select the field you wish to set as a drop-down field.
01:01 Then go to the "Lookup field" tab, choose "categories" as Parent table, and "Categories name" as parent caption field.
01:013 You can also list books that belong to a category when that category is selected.
01:24 Now we'll click "parent/children settings", check "enabled" and "show icon" and press "OK". All you need to do now is to generate.
01:43 Now, we'll switch back to see how adding new data goes.
01:51 Click "Add new" and start adding a new record.
02:05 You'll notice that "pages" field appears as radio buttons. To get to know how to create it, please visit our relevant tutorial.
02:11 Once you're done, click "save changes" than back to return to the table view.
02:21 You can click on any column title to sort data ascendingly, click again to sort descendingly.
02:27 Now let's jump to the "categories table" and see how books categorized as "Children story" are displayed.
02:52 You can simply edit your data by clicking on the arrow icon. A pop up window will appear, allowing you to edit, delete or save as copy.
To get to know more about AppGini, please visit our homepage for more video tours.