AnsweredAssumed Answered

Replacing a string with an associated code

Question asked by Marky1 on Aug 7, 2009
Latest reply on Aug 7, 2009 by Marky1


Replacing a string with an associated code




Im trying to develop a timesheet in which there is a drop down menu to select which project the staff have been using their time on. Once the user clicks Submit the Strings are swapped with their associated code and stored in the database. I am stuck on swapping out the strings with the codes. I was hoping to have one table for the timesheet entry data and a second table with the fields {Code, Name} and use the record ID or something? 

Any help on this would be great :)


Thanks, Marcus