[More than a Choice form table list]

[fulvio]

Hello everyone my name is fulvio, first of all, sorry for my bad english.

I am working on a DB for my comics (more than 4000) everything works perfectly (then I will share the work as I have been working on it for a long time and it might be useful for someone.)

I have created a list of designers, a list of stories, and the main list of comics.

I wish I could:

1- associate a story with a designer,
2- include multiple stories in a comic

I have read some posts but I can't find a solution
thanks for attention

[Villeroy]

See https://forum.openoffice.org/en/forum/v ... 00&t=40444 with attachment.

Each person has one animal which constitutes a one-to-many relation.
Each person can have many tools which constitues a many-to-many relation.
A many-to-many relation always requires a third table mapping the identifiers of each list (table P_T mapping person IDs to tool IDs).
A form which allows to edit a many-to-many relation has one of the lists as main form and the mapping table as subform. The subform needs to be a implemented as a table control having a list box column where you select (multiple) items from the other list into the mapping table.
[Person] ---> [P_T] <---[Tools]
or the other way round:
[Tool] ---> [P_T] <---[Persons]

[fulvio]

See https://forum.openoffice.org/en/forum/v ... 00&t=40444 with attachment.

Thanks a lot I'll give a look!!!