How do I specify data from a combo box?

[C.J.]

My problem that I am having is this. Based on the following example table:

A B C D
1 2 4 5
a b c d
w x y z

How do i get my drop down box to input the data from the last column (D)
into my table? In one of my forms, I have column (A) for my first drop down
box and I want to choose data from column (D) for my second drop down box.
If this is possible or not, give some ideas what direction I should take this.

Thanks. C.J.

 

[Jeff Boyce]

I'm a bit puzzled by the data example you provided. It looks like you have
fields (A, B, C, D) and rows of data ('1,2,3,4'; 'a,b,c,d'; 'w,x,y,z').

If I take this example literally, you have two different kinds of data
(numbers and letters) in the same field. What are the data types you've
defined for "A" and "B" and ...?

"How do I get my drop down box to input the data from ...(D) ...?" Why?!

If this table has a primary key field, each row has a unique row identifier.
You don't need to "copy" the data from column D in one table into another
table, you just need to store the rowID.

More info, please!

Regards

Jeff Boyce
Microsoft Office/Access MVP