hello all:

i have a table in which there are several foreign-key fields containing code values from which i want to create a parameterised view. while the parameterised view is not a problem, i want to incorporate fields from other primary key tables into the view whose primary key matches the foreign key value of the table in question. pls. advise.

hope i stand to be understood. thanks anyway :)