Auto-populating a multivalue field by another multi-value field checks

MyWebdots

Registered User.
Local time
Today, 08:05
Joined
Nov 8, 2010
Messages
11
Hi there everyone - not sure what happened but I asked this a few days ago - but my thread has disappeared - I wondered why know one was replying!! I can't have hit submit.

So I would really appreciate some further help if anyone has advice for me please.

My client has a WEED DATABASE. The first database they like - it has a form where you click on a WEED COMMON NAME field and select one weed per record. This auto populates another field. (SCIENTIFIC NAME) You can choose to select either Common name OR scientific name - and the other correct one comes up. This is managed by separate tables as FKs.

Now they would like the ability to do the same thing - but select SEVERAL weeds per record via a multivalue field with checkboxes. And would like in the 'other' multivalue field for the appropriate weeds selected. I don't think this is possible. Any ideas?? i am not very experienced in Database design and therefore may be missing a more appropriate alternative solution. (which I am open to!:) )

Many thanks in advance for any help.

Katie
 
Avoid multivalue fields regardless of their apparent appeal to the users. They just cause trouble.

You just need to add records to the join table. You can select them in a subform.
 

Users who are viewing this thread

Back
Top Bottom