nhorton79
Registered User.
- Local time
- Today, 14:29
- 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.
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.
