I have a puzzle and I was wondering if anyone can come up with a solution.
I have two schemas: personnel and awards
The personnel schema has a column for awards the person received. It's a lookup to the names of the awards, which are in the awards schema.
The awards schema has the award name and an image (those little colored ribbons soldiers wear on their dress uniforms) and the order (decimal value) of the awards to be displayed in.
The puzzle is we need to find a way to display the images of a person's awards (preferably in the right order) based on the awards they selected by name in the personnel schema.