table lookup acting weird

[Richie]

I have a set. A field in the parent table called cust id, I designed a lookup in a child table. Linking field is cust id Display order I put lastname so I was hoping would give me a a-z order of last names.
In the source fill section I put cust id to fill cust id and put lastname for display. I hit drop down list box and popup on enter.
Well it fills the id with the lastname even though the field id is 6 character width it will fill like lastname up to 16 characters.
What am I doing wrong?

[Stan Mathews]

Attaching a sample database so we can take a look would eliminate a lot of guessing.

[Richie]

I don't have the sightest idea of what you would want me to send you. All the tables in the set, forms, set configuation?

[Tom Cone Jr]

Stan (and others) would need the tables, indexes, and memo field files for the tables in the set; and the dictionaries for the tables in your set; and the set dictionaries. Check the help file discussion of "Alpha File Types" for details.

An easy alternative is to zip the entire database instead.

Attachments here become public, so delete any private or confidential data first.

To attach the zip file here use the "Go Advanced" button in the quick reply editor to open a more powerful message editor. Among it's faciilties is a "manage attachments" dialog that you use to attach, and then upload the zip file. Don't forget to "submit" the reply.

[Keith Hubert]

Hi Rich,

Well it fills the id with the lastname even though the field id is 6 character width it will fill like lastname up to 16 characters.
What am I doing wrong?

On the face of it, nothing. What do you want to happen that is not happening?