Relating records within a table
My question is whether it is possible to have a relationship among records within the same table?
I have a database for project management. One of the tables is for sites that take part in the project. Usually for each project there is only one primary site. However, that primary site may also have sites that do work. Can I relate records within the table or do I need two different tables? If the records can be related, how is it done?
/---- Sec Site
Project ------ Prim Site ------ Sec Site
\--- Sec Site