![]() ![]() I did not find an example addressing my case, but after seeing similar ones, the best I could come up with was: So, when the form is open and shows the publication with ID 1, the listbox should show the authors of publication 1, then when I navigate to the next publication, the authors should be shown the authors of the next publication.Īfter searching around for documentation and examples, I couldn't find a good description of the Libre Office object model. Now I want the parameter publicationid to automatically have the value of the field txtPublicationID which is located on the same form as my listbox. SELECT "Author"."Surname" FROM "Author", "AuthorsAndPublications" WHERE "AuthorsAndPublications"."FK_Author" = "Author"."ID" AND "AuthorsAndPublications"."FK_Publication" = :publicationid I want to create a form based around the table "Publication", but it should show all the authors of the current publication in a non-editable listbox.Īs the datasource for the listbox, I wrote the SQL query ![]() I have a table called "Author" and another table called "Publication", connected by a third table "AuthorsAndPublications" (it is an m:n relationship). ![]() I am building a form in it, and got into a problem. I have an embedded database in Libre Office. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |