![]() ![]() My two tables are as follows: Table 1 is named 'Prefectures' and has the following fields: ID, 'Prefecture Name', and 'State' Table 2 is named 'Ward' and has the following fields: ID, 'Ward Name', and Prefecture ID which is a foreign key referencing table 1. Note on the properties window that you can easily assign an "Action" to the button from the drop down list, in this instance "Previous Record" was chosen. Im using LibreOffice Base Version 1:3.6.2 and it has the default HSQL engine. "pbPreviousCourseStudent" is highlighted in yellow in the properties window with a green arrow pointing to the relevent button. In the Navigator you can see that "dsCoursesOverview" has the buttons "pbNextCourse" and "pbPreviousCourse" attached to it and further to that there is a sub datasource (linked to dsCourseOverview via properties link master and link child fields) called "dsCourseStudent" that has the buttons "pbNextCourseStudent" and "pbPreviousCourseStudent" If you look at the "Form Navigator" panel, you will see that various buttons have been attached to various datasources, this is easiest accomplished by clicking the datasource prior to drawing the button. ![]() These are kinda necessary when building your forms, but you most likely dont want them displayed when your database is in use, so just untick them when using the database. The toolbars menu is displayed, showing you that the "Form Controls", "Form Design" and "Standard" toolbars are displayed. Above image represents the form in design view. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |