Hi, please can someone explain in simple term...

(Nick Parsons) #1

Hi, please can someone explain in simple terms!! for me!! :wink: what this expression will do?

Where it will look and how it works.

Its basic I know but I need to fully understand it…

=[Audit ID].[Auditor ID]

(Syed Faheemuddin) #2

Let’s suppose you have two tables. Table1: Audits

Col1: Audit ID

Col2: Auditor ID

Col3: Name

Col4: Phone no

Tables2: Transaction Info

Col1: Transaction No

Col2: Transaction Date

Col3: Audit ID (type: ref,

refTable: Audits)

Col4: Auditor ID (type: text, App formula: [Audit ID].[Auditor ID])

Col4 in table2 will give you Auditor ID from Col2 of table1, where Audit ID in Col1 of table1 and Col3 of table2 are same.

This is called dereferencing

(Nick Parsons) #3

@Sdfaheemuddin Brilliant, great explanation, thank you.