Please help!!!!

[tonynikki0181]

Hello! I am working on a database for a school project. Basically, I have created 3 tables which I will then create 3 forms and so on. This is a medical record database. When I key in the med rec number on the first table, I want that to copy to the med rec number on the second table and so on. Which will then be copied to the forms. I am not sure how to even begin to do this. I know very little about access. I am using 2007. Any help would be greatly appreciated.

 

[StarGrabber]

Hi tonynikki0181, welcome to the forum!

What you've described is the wrong approach. Every information in a database should be singular, that is, stored only once. If you need the med rec number somewhere else too, create tables which have an 1:n (one to many) relationship. With other words, put the primary key of your med number table as an additional field in any other tables. This would be the foreign key.

You can easily create relationships by drag & drop in the relationships window.
http://www.access-programmers.co.uk/forums/member.php?u=117803