Recent content by bpen91

Here's the complete design: "User" table has ID(auto num),FName,MName,LName,User,Pass,Type. "Admin and Teacher" table has ID,FName,MName,LName,Gender "Pupil" table has ID,FName,MName,LName,Gender,Batch,Section. Now this "Pupil" table will be used for the "Results" table too. Our teacher told...

I'm sorry I don't understand what you mean. :( Is it in the query design?? Please explain more..

Hello guys! I'm an ms access newbie here and have a question to ask.. Scenario: Supposing you have 4 Tables 1.)User 2.)Admin 3.)Teacher 4.)Pupil Now the "User" table has the ff. fields: ID(auto num),FName,MName,LName,User,Pass,Type. Now what I want to do is, if I add a new a record in the...