The video is a very basic set of relations. For more information see Chapter 3 - Tables in the LibreOffice basic guide found at this link. There are also samples you can download.
Relations are always from one table to another. "How to reverse direction relations?" does not make sense.
Also, if you want to edit or delete the relation, right mouse click on the relationship line.
There is a bit more information in the off-line help file (F1) if you have installed it.
Edit 2/12/17:
The relation "Type" cannot be picked from a list. It depends upon the field and what it can contain. A Primary Key
field or a field marked as Unique
must contain data in each record which is different from every other record in that table. A different field where you may be storing the "City" for an address would not be marked as such since the same city can be in many different records of the table.
Therefore, when creating a relation from a Primary Key
or Unique
field (type = "One") to another field such as the field containing "City" above (type = "Many"), you have created a One-To-Many
relationship. As you can see, this cannot be changed because of the field restrictions.
In the LO relationship windows only connections are setup up, without regard to how the connection will be used. Later in a query or view you can clarify a relationship between tables to be either, full join, inner join, left join or right join, depending on what your needs are. (Note, this is different from how the MS Access Relationships window works. In access join type hints are provided in the relationships window to later help setup the default query relationships.)
I have relation many to one but I want have relation one to many. http://imgur.com/bkuSLfM
@Pyroxar, I appreciate you asking here, and your question suggests you are confused by the first principles of relational database design. I suggest you buy a good book that explains the first principles behind and beneath relational databases. This stuff has been around for 40 years that I know of, and there are good textbooks on the subject that address first principles. (My handle here, EasyTrieve, is the name of the first database front end I ever used in the late 70s on a mainframe.) :-)