Dynamic Dropdown Box?
I have 2 tables. One is "Reps" and the other is "Accounts" One of the fields in the "Reps" table is Rep Name. One of the fields in the "Accounts" table is also Rep Name. I would like the Rap Name field in the Accounts table to be a drop down box populated by all of the rep names that I've created in the "Reps" table. This drop down would need to dynamicaly change when I add (or Remove) reps. Any ideas on how to do this?