G
Guest
i have table a and table b. in these 2 tables, i have a field n. field n is
inputed from different users so in table a, the data reads as xyz, and in
table b the data reads xyz-1. i am making a query that asks for parameter
from a 2'nd field--field s. field s is in table a. when field s parameter
is entered, i want field n in table b to be displayed. if the parameter i
asked for was for field n, then i would put like [feld n] & "*"--how would i
get field n in table b (xyz-1) going through a different parameter?
--
inputed from different users so in table a, the data reads as xyz, and in
table b the data reads xyz-1. i am making a query that asks for parameter
from a 2'nd field--field s. field s is in table a. when field s parameter
is entered, i want field n in table b to be displayed. if the parameter i
asked for was for field n, then i would put like [feld n] & "*"--how would i
get field n in table b (xyz-1) going through a different parameter?
--