A
Andy G
Hi everyone,
I have a combo box that selects from a table of DRUGS
ID (autonumber)
DRUG (Text)
second table called DRUGS_Sub (COMBO BOX ON FORM)
this table is to store drugs from selecting option (other) in parent
table DRUGS
ID (autonumber)
ID_DRUGS_FK
SUB (text)
Third Table to link (NEED TO UPDATE THIS TABLE FROM FORM)
CUST_X_DRUGS
ID_DRUGS_FK
ID_CUST_FK
CUST table
ID
ID_DRUGS_FK (M-M)
.... amongst other things
from looking at code avalable from your threads and links I've managed
to get the first combo to select items in second combo based on first
choice.
What I want to know is how in my form do I get the third table to fill
in cust ID when data entered in drugs etc I'm only storing the autoid.
So basically I want to store under CUST table a link to what drugs
they are using from my list and if they choose other then be able to
add another drug.
It would be nice to make this a multiple selection. to store and
provide statistics on.
(Limited programming experience C++)trying to understand VBA
Help of anykind muchly appreciated
Andy
I have a combo box that selects from a table of DRUGS
ID (autonumber)
DRUG (Text)
second table called DRUGS_Sub (COMBO BOX ON FORM)
this table is to store drugs from selecting option (other) in parent
table DRUGS
ID (autonumber)
ID_DRUGS_FK
SUB (text)
Third Table to link (NEED TO UPDATE THIS TABLE FROM FORM)
CUST_X_DRUGS
ID_DRUGS_FK
ID_CUST_FK
CUST table
ID
ID_DRUGS_FK (M-M)
.... amongst other things
from looking at code avalable from your threads and links I've managed
to get the first combo to select items in second combo based on first
choice.
What I want to know is how in my form do I get the third table to fill
in cust ID when data entered in drugs etc I'm only storing the autoid.
So basically I want to store under CUST table a link to what drugs
they are using from my list and if they choose other then be able to
add another drug.
It would be nice to make this a multiple selection. to store and
provide statistics on.
(Limited programming experience C++)trying to understand VBA
Help of anykind muchly appreciated
Andy