Adding new data without replacing existing data

natek

New member
Local time
Today, 12:36
Joined
Jul 17, 2012
Messages
2
I am fairly new to Access 2007 and I have been assigned to create a database for a project that has been given to me. Basically it is a DB to keep a record of all sorts of info on our companies shareholders. With this DB, one of the functions it needs to have is to use a form to update a table that will generate quarterly payments based on the dividend rate. For example, lets say we have 20 shareholders, each with x amount of shares in the company. On June 1st, (the decoration date) we need to pay them $1.75/share. The table will need to automatically create rows of data such as transaction id (primary key), date, price, shareholder's name, and total payment (price x shares). I think I can get this to work once, but then when September 1st rolls around, I need to do this again, while I maintain the payment history. So I can not replace the existing data that I created in June. I will also add that I am not actually cutting checks from Access, only exporting data to import into our payment software. The function I need is to keep records of updated info. So what should my table look like? form look like? relationships? etc.

My apologies up front for me being a noobie and all so detailed help is always preferred. Thanks to anyone who can aid.
 
You're going to have a one-to-many relationship in your tables, with the table that tracks the payments on the "many" side. You should include a field to track the date of payment, such as Payment_Date, that will uniquely identify each payment. Basically, this table track all payments, maintaining a payment history.
 
Thanks for the reply. I will try to use your suggestions and get back to you after I play around with that a bit. still trying to get a more complete grasp on how to build the relationships and create the forms for the functionality I am looking to do.
 

Users who are viewing this thread

Back
Top Bottom