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