Help - Lookup Issues (looking up a referenced field)

[Ahnetworks]

OK, Here is my issue:

CustomerTable:
PK:CustomerName

AgreementTable
PK:[Lookup]CustomerName from Customer Table:Agreement#

AddendumTable
PK:[Lookup] Customer Name:Agreement# from Agreement Table


So, Each customer may have more than one agreement.
Each agreement may have more than one addendum.

So when I create a table to create a new addendum, naturally I would like to link this to an agreement (which has already been linked to a customer). When I do the lookup wizard for the agreement field however, instead of being returned a list of customers, i get the PK of the customer and not the customer name.

How do I get the lookup to show the customer name and not the PK.

 

[tpeter]

When you go throught the lookup wizard are you selecting the name and hiding the PK? If so and you are using the info on a form you can go into the properties of that control. Look at number of colums and make sure it has 2. Next if you have two colums look at the colume size. If it only have one value that is your problem. You need to have a value for both colums, example would be 0;2". This will hide the PK and only show the Name.