Digital archaeology

A GIS point layer is connected to excavation records stored in a separate database. Which practice most reliably preserves that link as the project grows?