Creating Record to Table from Another Record in the Same Table
I am creating a database that tracks acts of plagiarism that have been caught. I have it set up with a table for info and one for the documents (this is the list of plagiarism, the course, the person, etc). In the documents table, I would like to track WHO the plagiarism was copied from. When I do this, I would like to automatically populate a new record with this information.
ID 2045 Thomas, Brian in Spring 2011 Intro to Business | Paper taken from ID 3201 Frank, Michael in Fall 2010 Intro to Business
Both students would need a record of the plagiarism and would like to be able to do it one layout. Possible?