Hi, please can someone explain in simple terms!! for me!! 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]
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
@Sdfaheemuddin Brilliant, great explanation, thank you.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |