Hey all, simple question:
I have two tables.
"Table Fees" contains a list of fees and their information.
ID | Name | Charge 1 | Fee A | 10 2 | Fee B | 20 3 | Fee C | 30
"Table Associated Fees" contains a list of fees, as they apply to a customer, with other information.
ID | Customer | Fee | Modded Charge 3 | 100 | 2 | 25
In the second table, the 3rd defined fee is associated to customer #100, is based off of Fee B, and is modified to charge $25 instead of $20.
The problem is, in the drop down list model, it autoselects an option based on matching IDs. Fee C would be selected, not Fee B.
How would I change this?