How to calculate this..
I have a drop down field that pulls data from a related table.
Since (unless I'm wrong, and if i am please correct me) after selecting, the ID is displayed and not the name. So I created another field under it, and what I want to do and have that field display the name.
How would I do this.
(In case you wanted some info - Drop down (HotelID_FK) pulls a specified list from a related table(hotel) HotelID.
Current layout/table is specified as Work Placement)
Thanks in advanced.