It feels like I've been trying to solve a Rubik's cube in the dark. I've got most pieces in place but have hit a stopping point...
The relationship?
1 - 1st form where the user enters two or more cars (car table).
2 - 2nd form has options (ie. everything from full size spare, to seat material, to color) available in several categories where they can select values (0,1,2,3) from a look-up table on how important each of these options are.
3 - 3rd form - Crash! For each option I now want the user to set a rating for each option comparing each car against each other. Example: For an option of seat material the user should be able to rate one car as a "3" for one car and a "1" for the other...and be able to do this for all options.
I've tried different types of relationships and queries but just can't seem to get it. I'm pretty sure its a Relationship, but... Ideas?
Thanks.