Hello all. New member here. I have searched so forgive me if this has been covered or I've posted to the wrong thread.
First, I'm new to Access and databases (self taught) in general. I work for a school, and what I am trying to do is set up a table that will keep track of every time we send or receive a students records. Then I want to be able to enter a students I.D. number to get a complete record of requests, whether to or from our school, but I don't want a record overwritten.
I'm looking to acheive something like this:
ID Last Name First Name Date Sent To From Comment
002548 Student Ima 10/01/18 Franklin HS Records request from Franklin
002548 Student Ima 10/08/18 Franklin HS Records returned to Austin HS
002548 Student Ima 12/11/18 Raunson Acadamy Student in junvinile detention for 2 weeks
The way I have my Db setup now, everytime a students ID is entered, the To/From info is overwritten. I want to have To/From info on the first table overwritten and a second table that is added to each time new info is entered to acheive something similar to the above. AND I would like to do it from the same form. Does this make sense? Is this something too advanced for a beginner? Has my grasp exceeded my reach? Thanks for any info or advice you are able to provide.