I am using an ID col as the Key, and the ref ...

references
(Tammi Canelli) #1

I am using an ID col as the Key, and the ref is the first name col, but then on the referenced sheets instead of first name in that col i get the ID.

Should the ID columns be the reference AND the key?

(Philip Garrett) #2

The Ref field always contains the key of the referenced record.

We always find records by using their key.

(Tammi Canelli) #3

So if I need the first name to display what’s my best option? Add another col just for ref field?

(Philip Garrett) #4

See https://help.appsheet.com/data/columns/row-labels

(Tony Fader) #5

@Tammi_Canelli Here’s an example app, too: https://www.appsheet.com/samples/This-app-shows-the-difference-between-keys-and-row-labels?appGuidString=53280014-1d95-4d1f-93e5-a2a2e9be53a5

(Aleksi Alkio) #6

Basically it goes like this…

CustomerTable ID (Key column) Customer Name (Normally Label field)

Order Table ID (Key column) Customer ID (Ref type > Customer table)

(Tammi Canelli) #7

makes no sense.

i can’t get the first name to appear no matter what i try.

in my tables the first and last name are separate columns.

last name appears just fine.

(Tammi Canelli) #8

i need the name saved to the sheet not the id number

(Philip Garrett) #9

@Tammi_Canelli

The Ref must contain the key. That is how the referenced record is retrieved.

If you need to retrieve the name, or any other field value in the referenced record, you can always do so by using a de-reference expression.

For example, using Aleksi’s example, you could retrieve the customer name from the current Order record by writing: [Customer ID].[Customer Name]

If there was a Customer Address field in the customer record, you could retrieve it by writing: [Customer ID].[Customer Address]

You can use a virtual column to combine the first and last names to yield a label. This is described in this article https://help.appsheet.com/data/columns/row-labels