[Solved] List box multiple selection

pinkwar · Post by **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.

edit this topic's initial post · Post by **Villeroy** » Sat Aug 01, 2020 11:16 pm

viewtopic.php?f=13&t=96176&p=476547#p476547

Post by **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.

pinkwar · Post by **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.

[Solved] List box multiple selection

[Solved] List box multiple selection

Re: List box multiple selection

Re: List box multiple selection

Re: List box multiple selection