There are at least two different solutions to this. If the nature of the data entry is that everyone knows the choices for the hand types values, you can make a data entry field for the rate card. The Key field of that table would need to set to be the field that has the the values that the user will be typing.
Then you would change the field for [Related Rate Card] to be a formula field and the formula would be that data entry field.
You may want to try this on a COPY of your app first.
If you do need the option of both methods of entry say for new users or on a form, there is another solution.
