Using Ref list for drop downs seems to deliver different behavior

[Tina_Darbyshire]

Hello I am fairly new, building a straight forward app for service calls.

• I am using tables to use as ref for drop down lists in 3 areas. (These tables also have row #'s)

1. Company: used to choose a customer from a list. “Company” is used as Key and Label and populates my main data sheet with the proper “Company” information as well as shows properly in the app.

2. LCT: If I use “LCT” as key & Label, it populates my app with the row number and not the LCT’s name. If I change Key to Row number, it populates the app with the proper info but populates the spreadsheet with a row number instead of “LCT” data.

3. TCP: column is acting the same as above #2.

what am I doing incorrectly? Why does it work on one and not the others?