Auto fill student details into other tables without retyping

[Emmanuel Aboagye Nketsia]

(I am relatively new to ms access so this problem might have been solved for a different user, if so please direct me that post.) I am creating a database for my local school to :
1. Keep data of Students, their parents and etc.
2. Track school fees payments,
3. Track books distributions
4. payroll for the staff
etc

I wonder if there is a way to just type the name and class (basic details) of the students in only the details table and it will auto generate the same data in the school fees and other tables without having to retype the same data in the school fees table by creating a form to fill the student details

 

[CJ_London]

shouldn't be doing that anyway, database rules are (with a few exceptions not relevant here) to store data only once. Use a combo, listbox or subform to display the student data.

edit: sounds like you have not got to grips with database normalisation yet. It is not a difficult concept to understand. Google 'database normalisation' to find out more

 

[arnelgp]

you do not need to auto generate those info.
try also googling, Primary key and Foreign Key (on the joining tables).
in this way you can just Join your tables in a Query.

 

[GPGeorge]

(I am relatively new to ms access so this problem might have been solved for a different user, if so please direct me that post.) I am creating a database for my local school to :
1. Keep data of Students, their parents and etc.
2. Track school fees payments,
3. Track books distributions
4. payroll for the staff
etc

I wonder if there is a way to just type the name and class (basic details) of the students in only the details table and it will auto generate the same data in the school fees and other tables without having to retype the same data in the school fees table by creating a form to fill the student details

Actually, you've had the answer a couple of times already, but in your question, you bolded one of the main reasons Relational Databases were invented in the first place. "...without having to retype the same data in the [related] table..."

That concept is at the very heart of designing and building tables in a relational database application. You already know WHY you need to work this way, but now you must learn HOW to do it in the properly designed set of relational database application tables.