I have created a database for someone to manage an ongoing project that requires weekly invoicing to a client and payment to numerous subcontractors. I have three tables - a "master" table which contains the date (of books) received and invoice date, a "detail" table which contains the title and page count of each book as well as typist and client billing information, and a typist rate table which contains the typists' names and base page rates.
When she enters a book and associates it with a typist via a combo box, the typist page rate is automatically filled in and the total payment calculated based on the page rate and page count fields.
Occasionally, a typist may get a raise in her base page rate effective from that date forward. The way the database is currently structured, if there is historical data entered based on a page rate of, say, $1.50/page, and she gives that typist an increase to, say, $2/page, all of the historical data is automatically updated to $2/page.
How can I set up the tables and/or relationships (or whatever) to allow for increasing the base rate without changing the historical data?
Thanks in advance for any help!
Carenne [sig][/sig]
When she enters a book and associates it with a typist via a combo box, the typist page rate is automatically filled in and the total payment calculated based on the page rate and page count fields.
Occasionally, a typist may get a raise in her base page rate effective from that date forward. The way the database is currently structured, if there is historical data entered based on a page rate of, say, $1.50/page, and she gives that typist an increase to, say, $2/page, all of the historical data is automatically updated to $2/page.
How can I set up the tables and/or relationships (or whatever) to allow for increasing the base rate without changing the historical data?
Thanks in advance for any help!
Carenne [sig][/sig]
