These photos are real, only the first one was altered for better understanding of my question, and the more attentive eyes have already noticed that there are two names in blue, just like on Wikipedia. And this reflects my desire; that is: Is it possible to create a link to all the names entered in the “Main Actors” field that have a match in the table of another form, in the “Name” field?
I imagine I have to create a macro that controls the names typed in the “Main Actors” field and produces an auxiliary table with all the names separated, whenever there are modifications in its content, and then checks if they have a match in the “tblActores” table of the second form. If so, it establishes a link between them, and if not, it either moves on to the next name, if there is one, or ends.
The end result is what is desired in the first photo: the names with a match appear in blue or underlined, and clicking on them opens the other form with the correspondent name.
This is very common to see on the Internet, but is it possible to do this in LibreOffice Base? If so, are you willing to help me? Thank you for your availability.
Add a subform linked to its parent by the common names.
Thank you for your reply, but isn’t there another way? Does Wikipedia have subforms?
There is always another way, it is only software.
No. It is a Wiki (as one might guess fromm the name). So the store html-pages.
Depends on the meaning.
- I would understand this as: Can one create a report (in html), where the actors with own (preexisting) pages have links on their names. Can be done.
- What you can’t do is a hyperlink to a database entry. If you see that on the internet you have a link to a Webserver, wich runs a script to get a database-resultset, wich is then rendered by the script. In the early time this was the domain for PHP, but now there are several languages possible.
- The problem I see with your first picture is the violation of “one entry per row”, as you have a list of actors in one row there. So you need to assemble this list while constructing links in the query. An that leaves the question of the destination for the link. Here I see a macro as only possibility…
There are free developer toolkits to build your own Wikipedia, just like the other one.
Alternatively, you may build a small desktop database collecting links to the “real” Wikipedia. I can provide a macro opening http hyperlinks in your browser.
Okay. Let’s say I create a macro to split the names entered in the “Main Actors” field, which, in the photo, contains 6 names separated by commas, and I get a temporary table with the 6 names already separated. Then I query this table against the “Actors” table, which has n records, and retrieve the 2 names falsely marked in the photo. My question remains: of the 6 names indicated, 2 are registered in the “Actors” table, the others are not. Is it possible to make these names appear marked in the form so that a second form can be opened with the respective actor? I don’t want to create subforms or reports or anything else, I just want the names to be marked in the first form and linked to the second form, like in Wikipedia (that was an example). Is this possible with LibreOffice Base? Yes or no? If yes, how? Thank you.
Having a list of actors and a list of movies, you need another table linking actors and movies to each other. The attached demo has a table “CASTING” for this purpose.
Refer to the relations window:
The form maps each movie to multiple actors. It includes 2 hyperlink buttons trying to call the right Wikipedia page for the movie or actor respectively (see queries “URL_Actor” and “URL_Movie”).
I added a single movie with several actors.
ask128686_FB.odb (14.7 KB)
Dear Villeroy,
Thank you for your time, but my problem is not related to the construction of the database, but to the possibilities of linking names and forms. In other words, I want to open a form with only a specific record from the table associated with it.
Or, in another way: Let’s suppose I have a text box in a form where I put a name and there is an action button that executes a macro that tells me whether or not that name is in a table, and the way to tell me this is by underlining that name or changing its color. I would already be immensely happy with that. If LibreOffice can do that, then I think it can do the rest.
The file demonstrates how a many-to-many relation between actors and movies should be implemented in a relational database on the level of tables and indices. this way, you can query everything about a movie and its actors as well as everything about an actor and his/her movies.
When you pick one movie, the subform lists all of its actors. When you pick one actor, the sub-subform shows all the details of one actor. As long as your screen is large enough, this is far more convenient and faster than loading a new form window for each item. I just added the hyperlink buttons as a bridge to the world wide web.