Field with two codes - stops them showing on a list

I'm working in FileMaker 13. I have a field which holds a stock code e.g. ZA04646. I have a linked table which shows a list of all jobs that have used this stock code item (related records). Unfortunately someone has ordered more than one code stock item under the same job i.e. they've put in both ZA04646 and ZA04647.

Question

Is there any way I can enter more than one stock code into the same field (i.e. ZA04646, ZA04647) and still have them show up on the linked table that shows all instances of that particular code e.g. ZA04646 and ZA04647? At the moment when I put in both codes it doesn't show up for either ZA04646 items or ZA04647.

Is there any way I can enter more than one stock code into the same field (i.e. ZA04646, ZA04647) and still have them show up on the linked table that shows all instances of that particular code e.g. ZA04646 and ZA04647?

Yes, enter them as a return-separated list. Not a good practice in general, but as a quick fix ...

A match field that contains more than one value, each on a separate line. A multikey field can be used in one table involved in a relationship, to match several possible values in the match field of the other table. Sometimes called a complex key field.

Is there any way I can enter more than one stock code into the same field (i.e. ZA04646, ZA04647) and still have them show up on the linked table that shows all instances of that particular code e.g. ZA04646 and ZA04647?

Yes, enter them as a return-separated list. Not a good practice in general, but as a quick fix ...

A match field that contains more than one value, each on a separate line. A multikey field can be used in one table involved in a relationship, to match several possible values in the match field of the other table. Sometimes called a complex key field.