I think your insert should be trying to get records like this: 1414-3637 F01 1414-3637 F02 1414-3638 F02 1414-3638 F03 When you put comma separated values into a field, the DB checks that the string as a whole matches a single entry in the F_Orgs table.