populate a field from a list

[Guest]

Hi All,

I am trying to populate a field from a list in a form. I have a table set
up with a list of species and i need to be able to pick multiple species from
this list and link them to a wetland. I have succeeded in using a listbox to
populate a single species for a wetland, but when i change the multi select
field setting to simple or extended, i can no longer populate the field.

I'm afraid my knowledge of Access is very self-taught and i know diddley
about visual basic, so i am looking for the 'idiot's guide' on this one.

Any feedback muchly appreciated.

 

[Arvin Meyer [MVP]]

Adding multiple values to a single field violates all principles of
releational database design. To do it, is to invite problems further down
the design path. I suggest you add a table with a record for each species,
and the key value of the wetland. What you want to do is possible by
concatenating the multiple values together into a string. There is an
example on my website that does this to concatenate an email address string:

http://www.datastrat.com/Download/EmailSenate2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

thank you for your reply. I agree with your suggestion, however the client
is pretty keen on doing it this way, so i will persevere a little longer to
see if i can't give them what they want. If not, i will do it the other way.

Thanks again.