Hi geoff5,
Thank you very much for your help. Because of it, I'm making progress. I've done as your suggested, using the code that you specified. (Fields!Gender.Value happens to be the name of the foreign key in the primary table, as well as the name of the primary key in the lookup table, as you surmised.) However, when I used what you suggested I got the following 3 error messages, in this order:
Error1The Value expression for the text box ‘Gender’ refers to the field ‘Gender’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope.
Error2The Value expression for the text box ‘Gender’ refers to the field ‘Gender’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope.
Error3The Value expression for the text box ‘Gender’ refers to the field ‘GenderDesc’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope.
I'm not sure why I'm getting the same error for error #1 and #2, but I am.
Kindest Regards, Rod Connect with me on LinkedIn.