Mike, Your question is very generic so here is a bare bones answer.
Define all variables. Give your note field a component_id, say ci_complaint. Your user picks the type of complaint in a variable edit or a pick list (vpick). On Entry EEP into your note field: Based on the complaint type selected, you fetch the corresponding value from the complaint_table (but you don't overwrite what your user may have added to the field): If vcomplaint_text is null then Select complaint_text into vcomplaint_text indicator iv0 from complaint_table where complaint_type = .vpick PROPERTY ci_complaint textvalue .vcomplaint_text Endif I hope this helps a little. Claudine ________________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of mike epstein sony viao office Sent: Thursday, September 04, 2008 9:53 AM To: RBASE-L Mailing List Subject: [RBASE-L] - WALK MENU Good morning, I have a form that in which there is a note field to enter complaint calls for customer service application. Over the years we have collected unique values in a different table for the types of complaint as well as the complaint itself. Upon entry into the form field would there be a way to have the sentence auto filled using the data exclusively from the complaint table mentioned above. I realize that in a list view or popup menu one could choose the complaint but an autofill could work better. Mike Epstein --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
