When using the multiselect form type, if I have two items to select in my database things work fine. For example if I have a data set of 15,9 for a column in my database it will select the options with vaules of 15 and 9 in the multiselect. However, if I only have ONE integer in my data set, either 15 OR 9, no comma, no multiple data, the multiselect will not pre-select that option with the value of 15 or 9 by itself.
Break down of what I mean.
tech_id in my database shows 15,9
When I load the client profile it will select the tech names associated with id’s 15 and 9.
This is GOOD… this is what I want.
HOWEVER
if a profile does not have two technicians, things go wrong.
tech_id in my database shows 9
When I load the client profile, it will not select the option with the value of 9… it doesn’t select anything at all.
Any suggestions?