Name: [1922] Dai
Member: 100 months
Authored: 131 videos
Description: Hi I'm Dai Just an ordinary guy with an interest in computers who likes making how to videos for others to get the best out of there computers. I ounce did a course on web-design to further my interest in the subject. Got a HNC out of to boot but, lately my interest has turned to doing howto vide ...

Creating Relationships [ID:335] (3/15)

in series: OpenOffice Base

video tutorial by Dai, added 08/07

(Showmedo is undergoing major changes. To report any problems viewing the videos please email us and include browser and OS specifics. Cheers - Kyran.)

This tutorial will show you how to create a relationship between 2 tables

Got any questions?

Get answers in the ShowMeDo Learners Google Group.

Video statistics:

  • Video's rank shown in the most popular listing
  • Video plays: 26929 (since July 30th)
  • Plays in last week: 53
  • Published: 101 months ago

Thank-yous, questions and comments

If this video tutorial was helpful please take some time to say thank-you to the authors for their hard work. Feel free to ask questions. Let the author know why their video tutorial was useful - what are you learning about? Did the video tutorial save you time? Would you like to see more?

You may also want to see our ShowMeDo Google Group to speak to our active users and authors.

Your email address will not be published.

Show some quick comments >>

All comments excluding tick-boxed quick-comments

70. Ron Arredondo Sat, 16 Oct 2010 01:03

This one was good also. However, the list of fields that he shows within his "Appointments" in this tutorial has more then what he showed and did in his prior exercise. I remember seeing the entire list of fields in the overview video so I used that to guide me to add the missing fields in order to follow his instructions on this exercise. Could get confusing for some people.... Thanks again! -Ron

69. licuriciu Sat, 11 Sep 2010 01:17

this helped. :) thank you!

It has been very helpful. I like the simplicity it makes it easy for me to follow in this new forum of technology

I have just started your course. I am competent in Access and would prefer to migrate to Base for at least the smaller projects I do for voluntary organisations.


Very clear.

Great concise tutorial. I have constructed a few databases but always had problems with relaionships. This made it look so easy!

Excellent Tutorial so far. One of the bests.

Seeing a video makes it easier to understand than reading how to.

Thank you

Im new to using relational databases so it would be a big help if you could explain the relationships part but still very helpful

reg's Steve

61. Denise Van Wyk Sat, 05 Jun 2010 04:11

Great videos! Would refer all my students to this site!

60. Ninan Joseph Sat, 22 May 2010 22:47

Very useful

Hi Dai,

I hope to use your tutorial to build a database to keep a track of all my domains and web site work. I'll let you know how I get on

Great work :-)

57. Zach Brilhart Thu, 29 Apr 2010 10:03

Awesome vids. Needed this for my web design project. Was tearing my hair out reading the base help documentation. This was exactly what I needed.

Please make more on this subject.

55. Jóhann Gunnarsson Sat, 24 Apr 2010 16:05

Thanks, Dai, great videos!

54. John Williamson Wed, 21 Apr 2010 15:28

I thank you so much for your video's, they are a great help to me in understanding base

It's nice to know how to create a relationship. It would also be nice to know what the relationship means or does.

52. Madeline Tue, 06 Apr 2010 22:12

I'm hoping to use these tutorials with my students. So far, so good. Thank you for sharing.

Thank you for This Lessons , i am use openoffice few years and i like to write book about it .

50. Bill Gearhiser Sun, 21 Feb 2010 07:19

Great! Didn't even know this function existed.

49. honyczek Fri, 05 Feb 2010 02:11

Hello, this was good practical how to making relations. Thanks.

Dai -- just not clear. However, this is no matter of concern because I have only watched it once. I usually need to go over a procedure several times in order to remember the proper of sequence. In other words it is still too early for me to have formed an opinion regarding this video. SECOND WATCHING - LOOKS VERY GOOD - THANKS. I WAS EXPECTING A MINIMUM OF 5 WATCHINGS IN ORDER TO GET IT FIGURED OUT. THANKS.

Dai -- just not clear. However, this is no matter of concern because I have only watched it once. I usually need to go over a procedure several times in order to remember the proper of sequence. In other words it is still too early for me to have formed an opinion regarding this video.

Good to know how to make relationships, but for the complete beginner (like myself) you should say what it does. I saw what you did, but I don't know why.


Hey, I really like you database videos. You make it clear and easy to follow.

43. anonymous Wed, 06 Jan 2010 16:45

hello, just started to get tuition from your clips i like it because its is free and step by step...

thanks for making it available for ordinary people

42. anonymous Wed, 23 Dec 2009 18:34

Just thanks for Relationships. I tried it several times and had problems in the database it self. Followed your directions and error messages showed me the relations erros. May Thanks


41. anonymous Mon, 21 Dec 2009 16:01

Thanks for this service. It didnt quite solve my problem (I get an error message when trying to make links between 2 tables and dont quite know why) but I found your tutorial calm and thorough none the less. Happy Xmas

Showmedo is a peer-produced video-tutorials and screencasts site for free and open-source software (FOSS)- with the exception of some club videos, the large majority are free to watch and download.

how to help » about » faq »

Educating the Open-source Community With Showmedo

Although as important as the software it supports, education and documentation are relatively neglected in the Open-source world. Coders love to code, and explaining how best to use or improve the software tends to be deferred or even sidelined.

At Showmedo we believe the community can play a vital role here and also say thanks for the tools and software that make our lives easier. If you have a piece of software you love or a programming langugage you are enthusiastic about, why not make a screencast showing others how to use it? All the stuff you wish you'd been told, the tips, tricks, insights that would have saved you time and frustration.

Screencasting is easier than you think, and we're happy to help you. You can emailus for advice or just use some of the how-to screencasts on the site. This screencasting learning-pathis a good place to start.

Kudos and Thanks for Dai



Showmedo's development is fairly rapid and bugs will inevitably creep in. If you have any problems please drop us a line using the contact address below. Likewise, any suggestions for improvements to the site are gratefully received.