I want my combo box control to display two columns: BillingCode and Fee.
Right now, BillingCode is stored in the table.
I want the control to use the stored BillingCode and look up the appropriate fee, and then display both the code and the fee in the report.
I've tried playing with properties and setting up queries, but each time it only displays the code (the bound column) and not the fee.
Help! What am I doing wrong?
Right now, BillingCode is stored in the table.
I want the control to use the stored BillingCode and look up the appropriate fee, and then display both the code and the fee in the report.
I've tried playing with properties and setting up queries, but each time it only displays the code (the bound column) and not the fee.
Help! What am I doing wrong?