I have 3 tables. List of Employees (A), Issued Vouchers (B), and Claiming ©. Under them are the following columns:
List of Employees (A)
Full Name with the formula Concatenate([Last Name],", “,[First Name],” “,[Middle Name],” ",[Suffix])
Issued Vouchers (B): I wanted to autopopulate the other fields using dereferencing which worked.
Reference Number with the formula concatenate(Voucher Number],[Employee ID])
Employee Name with the formula [Full Name].[Full Name]
Voucher Number with the formula randbetween(10000,15000)
Employee ID with the formula [Full Name].[Employee ID]
Full Name as Ref Column referring to Table A
OTP with the formula Randbetween(300000,600000)
Claiming ©: I also wanted to Dereference from Table B so that the fields Full Name and Amount be filled automatically. The problem is the suggested values in the Reference Number Field has a yellow warning sign and the other fields don’t show up.
Reference Number as Ref Column referring to Table B
-this also has a formula for Suggested Values which is Issued Vouchers[Reference Number] as to minimize the error when inputting in this field.
Full Name with formula [Reference Number].[Full Name]
Amount with formula [Reference Number].[Amount]