In table #1 there are 2 fields "name" and "code". In table #2 there are the same 2 fields. The name field in table 2 is a radio button value list of the name fields from table #1. The code field in table#2 is a lookup of the code field from table #1.
For each name field in table#1, (red, blue, green, etc) there is a corresponding number in the code field. In table #2, I can select more then one name field at once (red and green..etc). If in table#1 red is "1" green is "2", the lookup result for the code field of table#2 should be "12", thus combining the codes from the selected name fields in table #1.
I am not sure how to achieve this.