[Solved] List box multiple selection

Discuss the database features

[Solved] List box multiple selection

Postby pinkwar » Sat Aug 01, 2020 9:54 pm

Hello OpenOffice community.

I've been searching for hours, watching youtube tutorials, reading and I can't find a solution for what I want to do.

It's very simple.

I have a "Book" and I want in the form to be able to select multiple "Towns" where the book is located.

I've tried to do this in many ways but I can't seem to do it.

I would greatly appreciate if someone can help me out.
Attachments
book database.odb
(26.4 KiB) Downloaded 8 times
Last edited by robleyd on Tue Aug 04, 2020 12:38 am, edited 2 times in total.
Reason: Add green tick
windows 10
openoffice 4.1.5
pinkwar
 
Posts: 2
Joined: Sat Aug 01, 2020 9:38 pm

Re: List box multiple selection

Postby Villeroy » Sat Aug 01, 2020 11:16 pm

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28434
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: List box multiple selection

Postby UnklDonald418 » Mon Aug 03, 2020 6:11 am

I added an intersection table BookXTown to handle the many to many relationship
Then added a form document Book2 a modified version of your Book.
I added another form document SQL to show the SQL statements I used to create the intersection table and the Listbox query.
Attachments
book database Mod1.odb
(42.65 KiB) Downloaded 7 times
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1322
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: List box multiple selection

Postby pinkwar » Mon Aug 03, 2020 4:17 pm

Thanks for both solutions.

Coming from Ms Access, I realize I'm very noob when it comes to databases. I really need to spend time learning SQL.

Issue has been solved.
windows 10
openoffice 4.1.5
pinkwar
 
Posts: 2
Joined: Sat Aug 01, 2020 9:38 pm


Return to Base

Who is online

Users browsing this forum: No registered users and 6 guests