Automatic Lookup Multiple Issue

Scriptcase 8 Discussion
#1

Hi

Please can someone help me?

In my mysql database have two tables - ‘staff’ and ‘staff roles’.

In my ‘staff’ table I have a field called ‘staff_role_id’ which pulls the data from the ‘staff roles’ table via an automatic lookup.

Now this select field works absolutely fine with single lookup values. However, as soon as I change this to ‘multiple’ (i.e. to assign more than one role per staff) and hit ‘save’ it overwrites all the other staff records and does not record more than one staff role.

Is this a glitch or what else do I need to do to get this to work?

Thanks in advance

#2

I assume no one else has experienced this problem and therefore it must be a bug?

#3

I suspect your staff_role_id is an int? Therefore only one staff role can be associated per record and thus the multiple won’t work that way (that’s why old selections are overwritten.) I believe you need to make that field in the staff table a large varchar type and select your separator. This way SC will store the multiple IDs in the text field and also be able to decode it.

Please note this is not an SC thing but a general coding technique.

Hope I understood your question correctly!

#4

Thank you very much. Still a newbie but lesson learnt!