AnsweredAssumed Answered

DropDownList display Id and not Description

Question asked by horses60 on Oct 18, 2011
Latest reply on Oct 18, 2011 by Jade

Title

DropDownList display Id and not Description

Post

Hello,

I have two tables in join: Peoples and Companies. In the table Peoples the foreign key to join Companies is Peoples::IdCompany.

I build a DropDownList on the field Peoples::IdCompany. In Inspector-Data-Display data from, I display Peoples::IdCompany.

The data are from a list.

The list use data from: first field = Companies::IdCompany and second filed = Companies::CompanyDescription. I show values only from second field.

When I open the dropDownList I see the descriptions, but after the choice I see only a number (the key).

I don’t understand how I can use a list to assign an Id from a related table and how display a description of thisId.

If I use a Pop-up menu the CompanyDescription is displayed.

Many thanks for the help.

Outcomes