1 Reply Latest reply on Jul 1, 2013 10:33 PM by bregent

    Database relationalal setup

    ottz0 Level 1

      I am making a relational SQL management studio database that is a document management system. I am going to bind the data in DW.

       

      I have created the relationship in SQL with primary and foriign keys.

       

      When a document is approved it is issued an approval number with a date, what I am trying to do is insert the approval number and date and then this record goes into the record table in which you can then select the document and view the history of record numbers and dates.

       

      Do I setup the approvalNumber and approvalDate in the main table and have the same fields in the approval table and how does this data write to the table with the forien key?

       

      Thanks

        • 1. Re: Database relationalal setup
          bregent Most Valuable Participant

          >Do I setup the approvalNumber and approvalDate in

          >the main table and have the same fields in the approval table

           

          Probably not, but you need to describe the two tables and their columns in more detail - including relationships.

          What DBMS are you using?