Have a field show the related value of another field
I have a drop down menu for an item in an invoice. that field stores the number related to the name of the item type listed in another table. I have a drop down menu occur when you click on it and that menu lists the item names. when you click on the item name in the list it enters the number associated to that name.
Example: you click on Labor and it enters "1" you click on Parts and it enters in "2" I want the field to show the related word in the Field just like it does in the menu. Right now when you click on Parts in the field it shows a "2" I want it to show "Parts".