Help with multiple lookup lists

[Adam H]

Apologies - i'm a "rookie" at Access - but i have searched for a while now on the site for the answer to my question... I'm sure there is a simple solution somwhere here but i cant find it!

I am putting togther an venue database - with all the usual fields: Name, Address, Capacity etc... of which i have set up YES/NO, Free Text and Number fields. No problem!

I have also set up various lookup lists which work fine, apart form the venue "Suitability" lookup list.

The choices are:

Corporate
Private
Drinks Reception
Dry Hire
Music Event
Conference

Now, some venues may be suitable for SEVERAL of these uses - so how do i select multiple uses from this list as opposed to just one?

Many thanks in advance for your help - im learning fast!

 

[ecniv]

Table with venue details
Table with lookups for suitability types
Table (VenueToSuitability) with VenueID and SuitabilityID

Then the form would need a multi-select listbox (probably) and possibly some code to store all selected items to the VenueToSuitability Table

This is only one options... Possibly you could use a subform for displaying and a popup to add?
Or a list box with a delete button next to it, and a pop up form to add to the list.


Vince

 

[Adam H]

Thanks Vince... much appreciated. I'll look into that,

*....hurries off to research how to create multi-select list boxes...*