Getting the Correct Column to Display in a Lookup

[Guest]

Hello

I am trying to reference an RMA number with a technical support call. (FYI, I have a table called "RMA" and a table called "Support Call".) When filling out the RMA form, I would like the user to reference the RMA they are generating to the technical support call they received. To do this, I would like to display (in a drop-down list) the date, customer name, and problem (from the Support Call table), and have the person filling out the form select the appropriate group that corresponds to the RMA being generated

However, when I do this, instead of the actual customer name and problem getting displayed for the user to select, I only get the key ID. I assume this is because the customer name and problem are not stored directly in my Support Call table; instead, they are referenced to a "Customer" and "Problem" table

Is there a way to tell the Lookup to go a step further and actually lookup the customer name, rather than simply displaying the key ID of that customer

Thanks in advance.

 

[Larry Daugherty]

Hi Drew,

First, please post in plain text. I , and many others, don't usually even
open posts that aren't in plain test.

Second, Go back to your table designs and get rid of all Lookup fields.
Yes, I know that you will have to chase the change in design through the
other things that rely on the tables. Lookup fields in tables are an
abomination brought to you courtesy of microsoft. You are experiencing one
of the problems seeded by Lookup Fields. You could probably work your way
out of the current problem by using a sub query but the underlying problem
(the Lookup Field) would remain.

HTH
--
-Larry-
--

Hello,

I am trying to reference an RMA number with a technical support call.

(FYI, I have a table called "RMA" and a table called "Support Call".) When
filling out the RMA form, I would like the user to reference the RMA they
are generating to the technical support call they received. To do this, I
would like to display (in a drop-down list) the date, customer name, and
problem (from the Support Call table), and have the person filling out the
form select the appropriate group that corresponds to the RMA being
generated.

However, when I do this, instead of the actual customer name and problem

getting displayed for the user to select, I only get the key ID. I assume
this is because the customer name and problem are not stored directly in my
Support Call table; instead, they are referenced to a "Customer" and
"Problem" table.

Is there a way to tell the Lookup to go a step further and actually lookup

the customer name, rather than simply displaying the key ID of that
customer?