LOL yeah sorry...
I have a table with a row that can store Employer Id and Agency Id for storing a list of talent that can be either employer talent or agency talent. I need to be able to display a list of them and be able to search by either employername or agencyname too.
So depending on whether the row is showing a employer id or agency id I need to search the relevant joined table.
ID, EmployerID, AgencyID
hope this helps?