Multi Value Combobox

[nhorton79]

Hi All. We track clients through Access (inhouse CRM/job management) and have discussed adding market segmentation to our clients.

Our database is actually through linked MySQL tables, not an Access database so just using Access for the forms, queries etc.

I imagine it would be easy to sort this in the backend tables, I.e add a tblSegmentation with id, segmentationName fields then add another table to allow M2M relationship tblClientSegmentation with ClientID_FK and SegmentionID_FK.

My issue is how to represent this on the form. Ideally the users would prefer to see this as a simple combobox that lists all segments that it multiselect, maybe with a checkbox near to each.

I feel I could easily do this as a listbox, but a combobox would be harder. Doesn’t a multiselect combobox only work with an MVF?

Would love some help here.

 

[DHookom]

Does MySQL support MVFs? I believe there is a recent thread in the Forms forum discussing this functionality.

 

[MajP]

You can fake a multiselect combobox.
Post in thread 'Form Design to Allow Multiple Selections (Add your Ideas)' https://www.access-programmers.co.u...selections-add-your-ideas.334421/post-1970121

 

[Ken Sheridan]

The attached StudentCourses file demonstrates a number of possible interfaces for a for a many-to-many relationship type. It includes a multi-select list box, or to save space in the form, a comma separated list. In the latter case the list is edited by means of small dialogue form opened from a button on the bound form. The dialogue from uses a multi-select list box.

A drawback of the above methods is, as with a MVF, that they can only model a binary relationship type, not a ternary one or greater. Also they do not allow non-key attributes of the relationship type to be included.

The standard interface is a subform in continuous forms or datasheet view, and my demo includes this. In this case the relationship type is ternary, and this is easily modelled in the subform, in which there are combo boxes for selecting both course and status.

 

[arnelgp]

you could also try the database on the Sample Database section:

Multi-value field (MVF) Faked Form.

simple demo to save in Normal table the values selected in Multi-value list. Related threads: https://www.access-programmers.co.uk/forums/threads/sorry-folks-access-world-will-not-accept-my-posts.334416/page-4#post-1970100...

www.access-programmers.co.uk