LibreOffice Base (63) Junction Tables part 1

preview_player
Показать описание
We add a new table for training and we want to list the training by employee as well as the employees by the training – this requires a junction table – that we create in this video and show how it works.

The downloads to go with this series can be found here:
  1. MichaelsTechTutorials
  2. LibreOffice (Software)
  3. Open Office
  4. base
  5. tutorial
  6. Junction table
Рекомендации по теме
LibreOffice Base (63) 0:08:13

LibreOffice Base (63) Junction Tables part 1

LibreOffice Base (65) 0:10:33

LibreOffice Base (65) Junction Tables part 3

LibreOffice Base (64) 0:11:21

LibreOffice Base (64) Junction Tables part 2

LibreOffice Base (62) 0:08:07

LibreOffice Base (62) Standalone Switchboard

LibreOffice Base (70) 0:13:31

LibreOffice Base (70) Reports – Conditional

LibreOffice Base (30) 0:04:51

LibreOffice Base (30) Why we need multiple tables

LibreOffice Base (02) 0:08:50

LibreOffice Base (02) Create a Table with the Table Wizard

LibreOffice Base (83) 0:10:18

LibreOffice Base (83) Connect Directly

LibreOffice Base (46) 0:10:44

LibreOffice Base (46) Form from Query

LibreOffice Base (37) 0:06:35

LibreOffice Base (37) Normalizing Part 1

LibreOffice Base (66) 0:07:05

LibreOffice Base (66) Intro to Reports

LibreOffice Base (73) 0:08:34

LibreOffice Base (73) Home Invoice pt1 Tables

LibreOffice Base (69) 0:15:03

LibreOffice Base (69) Reports – Intro to Grouping

LibreOffice Base (04) 0:06:39

LibreOffice Base (04) Create a Table Using a Calc File

LibreOffice Base (91) 0:10:39

LibreOffice Base (91) MySQL Relationships

LibreOffice Base (87) 0:09:15

LibreOffice Base (87) MySQL Workbench (2)

LibreOffice Base (08) 0:10:11

LibreOffice Base (08) Add Delete Fields and Tab Order

LibreOffice Base (38) 0:07:34

LibreOffice Base (38) Normalizing Part 2

LibreOffice Base (71) 0:10:30

LibreOffice Base (71) Reports – More Grouping pt 1

LibreOffice Base (88) 0:10:34

LibreOffice Base (88) mysql_searchform (1)

LibreOffice Base (61) 0:11:07

LibreOffice Base (61) Standalone Forms

LibreOffice Base (52) 0:07:49

LibreOffice Base (52) Combo Box

LibreOffice Base (36) 0:07:19

LibreOffice Base (36) Adding a Subform (to an existing form)

LibreOffice Base (40) 0:12:14

LibreOffice Base (40) SQL Join Tables part 1

Комментарии
Автор

I'm following all your LibreOffice Base serie from the beginning and I'd have to say you did a wonderful job explaining everything in detail.

davidboivin
Автор

Hi, your videos have been a huge help in understanding LibreOffice. Thank you! I have a question about subforms w/ junction tables. Is it possible to sort the list? Like in your example, sort the training alphabetically as opposed to the ID number. I'm using this to store events attended by a member of an organization, and would like to have the table sorted by event data - but the events may not be added to the event table sequentially.

mojoerose