AnsweredAssumed Answered

Relating records within a table

Question asked by jconner99 on Apr 12, 2010
Latest reply on Apr 12, 2010 by philmodjunk


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