J
JJ1109
Hi, quite new to this database thing I'm using Access 2000, I'm trying to
get a form to display a drop down box that has values from one table, and to
store those values in another table. I've managed the first part, no worries,
however I can't get the actual text to be stored in the new table: it stores
the key value instead.
I'll try to describe what I have here. I'm trying to track people using
consumables in my workplace. A form is filled in (on paper, how retro!)
saying who wants it, what they want and how much of it they want. I want to
put that info into the database so we can see who's using what and how often
(to justify expenses).
So Table1 is a list of Employees. Table2 is a list of consumables. Table 3
is everything else (date, quantity, name of person doing the request and name
of requested consumable). So obviously I want a form with a box where i
select the name of the person from the Employees table, then that name gets
stored in the name field in Table 3. And the same for the Consumable: select
from a list generated from Table2 and store the name in the relevant field in
Table3.
Like I said, I can't get the name displayed, only the Key. I'm guessing
there's something wrong with relationships I've set-up, however I don't fully
understand them: I've linked the primary key in Table1 to the Primary in
Table3, and the primary in Table2 to the primary in Table3. However if i try
to link things differently, it all falls apart and I can't see anything when
I try to view the form: I can see it in design view but can't see anything
when I switch to "view" mode.
Hope I've explained that in an understandable way, and sorry for the long
post!
cheers
JJ
get a form to display a drop down box that has values from one table, and to
store those values in another table. I've managed the first part, no worries,
however I can't get the actual text to be stored in the new table: it stores
the key value instead.
I'll try to describe what I have here. I'm trying to track people using
consumables in my workplace. A form is filled in (on paper, how retro!)
saying who wants it, what they want and how much of it they want. I want to
put that info into the database so we can see who's using what and how often
(to justify expenses).
So Table1 is a list of Employees. Table2 is a list of consumables. Table 3
is everything else (date, quantity, name of person doing the request and name
of requested consumable). So obviously I want a form with a box where i
select the name of the person from the Employees table, then that name gets
stored in the name field in Table 3. And the same for the Consumable: select
from a list generated from Table2 and store the name in the relevant field in
Table3.
Like I said, I can't get the name displayed, only the Key. I'm guessing
there's something wrong with relationships I've set-up, however I don't fully
understand them: I've linked the primary key in Table1 to the Primary in
Table3, and the primary in Table2 to the primary in Table3. However if i try
to link things differently, it all falls apart and I can't see anything when
I try to view the form: I can see it in design view but can't see anything
when I switch to "view" mode.
Hope I've explained that in an understandable way, and sorry for the long
post!
cheers
JJ