So its kinda Working now, just my reference is broken.
B. Contractor Policy Table
C. Company Table.
Company References the Company Table
Visitor Name references the Contractor Policy Table
Company Name References the Companies Table
I’m getting a Broken Reference on Table A for Visitor Name.
Select(Contractor Policies[Visitor Name], [_THISROW].[Company Name] = [Company Name])
Without This Formula, everything works perfectly. It just shows all the names, but I only want the names related to the selected company to show up when a user signs in or out.
Any Reason Why it works fine without formula but shows broken referance with formula? Is it my formula? Not sure what I should Change.