For example, we have 3 tables : Employee, Branch_Office, Designation, and their relationships are as following:
BranchID (FK) (reference to Branch_Office PK)
DesignationCode (FK) (reference to Designaiton PK)
Assume we have an employee (for example, EmployeeCode='E0001') works in Branch_Office(BranchID='B001', BranchName='California') and works as Designation(DesginationID='D0001', DesignationName='Administrator').
My problem is that I cannot full-text search an employee base on their BranchName or DesignationName.
It seems that full-text index created on only one table.
Can I full-text search on BranchName or DesignationName of an employee in this situation?