i have a table that is an intermediate table used to join two other table together. This table contains 3 fields (an autonumber prim key, the lmrp id -the prim key from my LMRP table and the diagnosis id which is the prim key from my dx table)
i am trying to figure out the best way to update that table. There are times i will have to input several hundred diagnosis codes in this but can;t seem to figure out how.
What i would like to be able to do is type the diagnoss (not he prime key id) and then append that info to the intermediate table. the trouble i'm having is that no matter what i do i always seem to be dealing with the diagnosis primary key and not the dx itself. if i set up the subform and use a list box for the diagnosis values (which works well for the data entry part)
(i know i'm not explaining this well and i'm sorry) ithink it's my frustration coming thru. this is the first time i've had to really deal much with many:many relationships and it's throwing me off.
Kyosa
"The key to flexibility is indecision!"
i am trying to figure out the best way to update that table. There are times i will have to input several hundred diagnosis codes in this but can;t seem to figure out how.
What i would like to be able to do is type the diagnoss (not he prime key id) and then append that info to the intermediate table. the trouble i'm having is that no matter what i do i always seem to be dealing with the diagnosis primary key and not the dx itself. if i set up the subform and use a list box for the diagnosis values (which works well for the data entry part)
(i know i'm not explaining this well and i'm sorry) ithink it's my frustration coming thru. this is the first time i've had to really deal much with many:many relationships and it's throwing me off.
Kyosa
"The key to flexibility is indecision!"