I want to implement a list where the user can select one more option. what kind of field should i select?
I have tried with enumeration but this type only allow to select one of the options.
Thank you for your attention
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.
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.
About This Community
|Asked: 2/13/20, 11:37 AM|
|Seen: 127 times|
|Last updated: 2/18/20, 10:27 AM|