I have one main table: Calls. And 3 other tables: Names A, Names B, Names C.
In Calls I have a field named "Name" which takes a text input. Based on this input I would like to fill in a field named "Category" with which table it came from.
I currently have 'Category' set as a Formula - Text field with the following formula:
If([Name]=[Names A - Name], "Names A", If([Name]=[Names B - Name],"Names B", If([Name]=[Names C - Name], "Names C", "Unknown")))
Regardless of what I enter it always seems to comeback as "Unknown".
How do I make this work?