Multi Value Combobox (2 Viewers)

nhorton79

Registered User.
Local time
Today, 16:43
Joined
Aug 17, 2015
Messages
149
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.
 
Does MySQL support MVFs? I believe there is a recent thread in the Forms forum discussing this functionality.
 

Users who are viewing this thread

Back
Top Bottom