I have two fields Country and Flags,flags is a container field and country is a text field using a value list/drop down menu.

Stored on my computer is a folder with various pictures of flags,the order corresponds with the order of the value list.

When the relevant country is selected, i want the corresponding flag to appear in the flag field,what would be the best way to do this.

Thanks

You need to have a table with 2 fields: country and flag. Flag is container field. You need to create a record for each country and insert the flag in the flag container (either physically or by reference to the file on your hard disk). Then you need a relationship from the country field in your original table to the country field in the new table. replace the flag container in the original table with the related flag container from the new table.

If you don't want to make the extra table then you can make it work your way but it will involve some heavy duty OS-level scripting (VBscript).

Or,

Check out this sample file, ino has already done the work.

Sample File Topic

Lee