Welcome!

This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!

2

0
Rodrigo Serafim
On 2/13/20, 2:03 PM

That is not only a question of the type of control to use. If you need to select multiple things then you need to persist a list of things in the database instead of a single thing. So your relational model needs to define this additional list with a N:N table.

The control you are looking for is the "Checklist". It cannot be a dropdown because you are selecting multiple things. You will need to supply it the N:N table that will record the items you select.

For example, if you have Clubs and Persons and you want to associate multiple persons to a Club you will need a N:N table (call it Member) that relates to both a Club and a Person. The checklist will be based on Member and will be placed on a form of Club and it will show the name of the Person in the columns.




0
Carlos Nogueira
On 2/13/20, 1:54 PM

Hi,

Enumeration or Array Choice will not serve your purpose. Genio doesn't have (yet) what you described. Meanwhile, you have 2 possible implementations. It depends on the data volume of the list and the business requirements, you can use one or the other:

1 - If the list is small enough, it can be implemented as one field (logic) representing one option;

2 - If the list is big and mantained though the application interface, it can be a simple table (where it will be filled after)

Using option 2, there is one control (N:N Checklist) where it associates the records through a 3rd table automatically. 


Hope this suits your needs.


Keep Informed

About This Community

This platform is for beginners and experts willing to share their Genio knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers. Read Guidelines

Question tools

17 follower(s)

Stats

Asked: 2/13/20, 11:37 AM
Seen: 66 times
Last updated: 2/18/20, 10:27 AM