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?
>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?