AnsweredAssumed Answered

Populating a field based on user selection

Question asked by revmk on Aug 13, 2010
Latest reply on Aug 13, 2010 by philmodjunk


Populating a field based on user selection


Hi all,

I have a letter table which contains some basic information for the letter (date created, name, text and client reference).  I have been asked to put in some basic pre-prepared letter texts which the users can define and select when entering this mode (to save time I guess).

My idea was to create a seperate table with the 'pre-defined letters' in (name of letter & text to use fields).  However I have confused myself. 

If I do this can I use an edit field in drop down mode to return all the records in the pre-defined text table and then populate my letter text field and name field with the contents of the selection?  

I can not for the life of me work out how to do this.


Edit: I should note that beyond the text being pasted in there is no relationship between them required.