Hi David,
 
I do have just the report for you.  At the top under the under line I expanded a subreport that has the Conservation related Attribute Types in a Parameter.  This Parameter appears with the list in the window in TMS -- because it is in a Subreport after the normal Gallery Systems param window.  Users can use the actual list to choose their terms.  No typos.  I use formulas to pull their answers and the data that relates to their choices back into the Main report.  These formulas are the nearly invisible squares in the two sections following the subreport.
 
Look this report over and let me know what questions you have.  It is a bit complicated to hand off without explaining all that I am doing.
 
Are you going to Amsterdam?  Hope all is good with you!
Carole.

>>> On Thursday, February 26, 2009 at 3:57 PM, "Aylsworth, David" <[log in to unmask]> wrote:

Before I waste too much time trying to figure out something that isn't actually possible, have any of you added parameters to a report that have a controlled list of options to choose from rather than allowing people to fill in free text?  It doesn't seem obvious to me how to do that if it is possible.

 

I'm trying to write a basic conservation request form, but the conservators only want people who fill out the form to have a limited number of things that they can request.  Do any of you have suggestions for how to accomplish this?

 

I'd appreciate any advice you can give.

 

Thanks,

David

 

David Aylsworth

Collections Registar

Museum of Fine Arts, Houston

tel:  713-639-7824

fax: 713-639-7780