Thanks for looking at my question. Here’s what I’m trying to do:
I have multiple Tables in a Base; “Primary DB”, “DB2”, “DB3”, etc…
Inside of the “Primary DB” there are two Fields called “Company Name” and “Other DB”. The “Company Name” field is populated with … company names.
In all the other Tables I have one Field called “Company Name”.
I would like to create a formula in the Primary DB table / Other DB field that checks the values of the "“DB2” table / “Company Name” field, and if the values match, to fill in the Table name (“DB2” in this example).
And then for “DB3” and so on.
Is this possible?