First off - I'm a complete novice at this, so go easy on me please

I've imported a file that was originally in MS Access and a few of the fields need to have multiple values in them. The field concerned - advert type - could be (for example), Platinum, Gold, Silver, Bronze, and these values have been put into a separate table so it can act as a lookup table. Sometimes I need to select more than just one type. I finally found the Inspector and the control style is pop up menu and the "values from" refer to the correct table. However, when I go back to browse mode and then try and select more than one option (have tried every key going with a click), it won't select the two of them. What am I doing wrong?!

Thank you for your help

D

Hold down shift and select each one.

Automatic message

This topic has been moved from "The Presentation Layer → Advanced & Developer Features" to "Database Schema & Business Logic → Value Lists".

Hi Deb, welcome to FMForums!!

I would suggest you use checkbox if there is the space - since it allows multiple values to be selected naturally. Selecting multiple items using drop-down list or pop-up menu can be a problem because, if a User forgets there are multiple 'checked' items already in the field, and if they forget to hold down shift EVEN ONCE, they will accidentally remove all prior entries (possibly entered by someone else?).

I would suggest you use checkbox if there is the space...

I was going to suggest that too, but.

... (for example), Platinum, Gold, Silver, Bronze, and these values

Sounded like the tip of the ice berg and was waiting for D to reply.

Anyway, great minds lol :)

The field concerned - advert type - could be (for example), Platinum, Gold, Silver, Bronze, and these values have been put into a separate table so it can act as a lookup table.

Not sure what you mean by "act as a lookup table". An actual lookup will only occur from the first related record - so if you need anything more complex than just tagging an advert as belonging to one or several types, you should consider adding a join table.

I was going to suggest that too, but.

Sounded like the tip of the ice berg and was waiting for D to reply.

Anyway, great minds lol

Sorry - posted this and then finished work for the day .

Thanks for the help - will give it a go and let you know how I go.......