Hi to all, I am pretty new in creating databases, so I ask for your patience. English is not my native language, so I may do few mistakes. I ask for your patience

I am creating a database. What I want is to create a dropdown list with three choises. When a user selects, lets say "Option A" I want a specific image (such as image-a.jpg) to appear in a certain field. When he chooses "option B" another image (image-b.jpg) should be "attached" in this particular field and so on.

What are the steps that I have to follow? Please try to be as specific as possible!

Thank you very much for your help!

George

Hi

1) create a new repeating global container field with 3 repetitions ( name it: images )

2) while in Browse mode insert, into each repetition, your images.

3) create a calculation, result type container, with this calc:

Case(

YourDropDownField = "Option A" ; images[1] ;

YourDropDownField = "Option B" ; images[2] ;

YourDropDownField = "Option C" ; images[3]

)

Note that:

a ) the repeating global container could stay into another table, even not related.

b ) YourDropDownField is the name of your current field, formatted as a drop down list.

I did all that you mentioned (thank you very very much!!!) but when I create a new record, fields images[1], images[2] and images[3] remain blanc. The same for the field "result". What did I do wrong?

(Where "result" is the calculation field)

... you didn't make the repetition field "global".

To make it global, check the Storage option for that field.

You are amazing! Thanks again!