Jump to content

Flags/Country


This topic is 5670 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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).

Link to comment
Share on other sites

This topic is 5670 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.