I apologize if this has already been discussed in a thread, but I am new to php and sql and trying to follow along with some guides to learn them by creating a contact matrix for work. In this database, it will have a table for employees, a table for supervisors, a table for departments, teams, and divisions, and a table for tasks. I am primarily focused on the employee table for this question, and on the employee table it will have the employee’s first name, last name, their contact information (phone, fax, email) and also their supervisor’s name. Now the supervisor is also an employee with their own record in the database, and their employee record also includes their supervisor, and so on.
So the question is whether it is possible to create a column in the table which will be the name of the person’s supervisor along with a link to that supervisor’s contact information. I keep thinking about this in terms of html and the tag (something like John Smith ), but I don’t know whether it is possible to do this without doing a query in the database. Can a query be inserted into a column of a table to automatically bring you to another record “on click”? Any help with this would be greatly appreciated it.
P.S. - if it simply cannot be done, please let me know. I’d rather give up than to agonize over trying to figure this out. If you don’t know how to do this without spending large amounts of time, I don’t mind doing the research myself, I just don’t know what to search for. If there is name for it, let me know and I will gladly look it up and get learning!