OK, on my form I have customer ID, customer code, meal type, and meal cost fields. When I enter in a customer ID, the customer code is filled in automatically (that's working). What I need is to display and save to the table the meal cost depending on what the customer code is and the meal type. Here is an example:
If the customer code is 101 and the meal type is brk then meal cost is $1.25
If the customer code is 101 and the meal type is lun then meal cost is $1.75
If the customer code is 202 and the meal type is brk then meal cost is $2.00
ETC..
Thanks for reading this. I hope it makes sense!