Field lookup in SQLS tables

  • Thread starter Thread starter Rajat
  • Start date Start date
R

Rajat

Hi,

I have just ported my app from MDB to ADP.

I have two tables that have a PK-FK relationship. The
table with the FK refrences the PK of the other table.
However, I want to use a different field both in the
display and the lookup for the field.

I was able to do this in MDB tables by going to table
design>lookup and changing the rowsource for the field.

How should I do this in ADP/SQLS?

Thanks,

Rajat
 
You can't do it using SQL Server (and you'll find that there are a large
number of people who wish it wasn't possible using Access! See
http://www.mvps.org/access/lookupfields.htm at "The Access Web" for an
indication of why)

However, this needn't be a limitation. Since you should never be working
directly with the tables and should always be using a form, bind the field
in question to a combo box that has the key value as the bound column and
displays the descriptive field in the combo.
 
Back
Top