Employee-ID in the sub-form table has two decimal places ("1.00" instead of "1") although in the table it's an integer. If you don't like that, go to the edit mode right-click on the column name (employee-ID) and choose "Column...", in the dialog box set decimal accuracy to 0.
HiYour series LibreOfficeBase (36...etc) is absolutely brilliant. I love your steady, methodical, calm approach. It's taken me from a totally "green" Database novice to constructing a very useful Dbase for my small business. The one thing that I can't obviously see how to achieve is change the column heading names (Dbase field names) to something more user friendly. For example: Database Field name "purchase_qty" to simply "Qty" on fields when they are displayed in a spreadsheet style layout for example as a subform. In my particular real life example I have "Customers" table & an "Orders" (one to many relationship). For the customer Mr Smith" I want to show all of their orders in a spreadsheet style subform, but with user friendly column headings.Your help would be greatly appreciated.TksSteve
+Stephen Pearce Hi Stephen, check out video #19 Alias and Sort found at: th-cam.com/video/o-R6FpZufJQ/w-d-xo.html. I think that is what you are looking for.
Quick question! - I'm following your instructions in creating a subform in an existing form, but the "field selection" dialog doesn't pop up when I drag out a table control box. Any ideas??
at 6:32 you're deleting a field inside a form control. What is the right way to add a field to a form control (master or slave, no matter) If I right click on the header bar, there's "insert column" option, but the opening menu doesn't give me fields, for some weird reason it shows control objects. I figured out it's possible to open a table in another window and drag onto a 'table control' inside a form. But what is the right way to do it? this feels like a hack
wow thank you.
i've been looking all over the internet on how to manually add sub-form in libre
Very clear. Thanks very much for doing this.
thank you very much for this video
Excelent!
6:25 editing subform columns is as easy right clicking on the column header!
Employee-ID in the sub-form table has two decimal places ("1.00" instead of "1") although in the table it's an integer. If you don't like that, go to the edit mode right-click on the column name (employee-ID) and choose "Column...", in the dialog box set decimal accuracy to 0.
HiYour series LibreOfficeBase (36...etc) is absolutely brilliant. I love your steady, methodical, calm approach. It's taken me from a totally "green" Database novice to constructing a very useful Dbase for my small business. The one thing that I can't obviously see how to achieve is change the column heading names (Dbase field names) to something more user friendly. For example: Database Field name "purchase_qty" to simply "Qty" on fields when they are displayed in a spreadsheet style layout for example as a subform. In my particular real life example I have "Customers" table & an "Orders" (one to many relationship). For the customer Mr Smith" I want to show all of their orders in a spreadsheet style subform, but with user friendly column headings.Your help would be greatly appreciated.TksSteve
+Stephen Pearce Hi Stephen, check out video #19 Alias and Sort found at: th-cam.com/video/o-R6FpZufJQ/w-d-xo.html. I think that is what you are looking for.
Quick question! - I'm following your instructions in creating a subform in an existing form, but the "field selection" dialog doesn't pop up when I drag out a table control box. Any ideas??
+Heidi Wai-Yee Chan On your Form controls toolbar, make sure Wizards On/Off is turned On.
at 6:32 you're deleting a field inside a form control. What is the right way to add a field to a form control (master or slave, no matter)
If I right click on the header bar, there's "insert column" option, but the opening menu doesn't give me fields, for some weird reason it shows control objects. I figured out it's possible to open a table in another window and drag onto a 'table control' inside a form. But what is the right way to do it? this feels like a hack
nice one
Are you still around?