kirstiem85
New member
- Local time
- Today, 21:51
- Joined
- May 31, 2014
- Messages
- 2
:banghead:
Hello
SO far Iv'e got every book in the library watched every tutorial video and this is the first time Iv'e joined a forum so I'm pretty desperate to work this out!
I clicked on Access by accident one day and was curious and delighted Iv'e been playing around with it non stop and I'm a COMPLETE beginner but I'm really really stumped on the following...
I am using the student template database but wanted to change a few things.
I am a teacher and I get referrals of students I then interview them (if they show up) So I have created a table and form for referrals which tracks where they came from, contact info etc then if I accept them onto the course I want a check box or similar to then transport them into the main student list with more in depth info such as medical etc.
My problem is how to relate the two tables and if accepted duplicate some of the fields I already have for that person, if not accepted for them to remain on my referral list.
Is it possible once I have the database set up I can somehow fill in fields and get the database to autofill in paperwork pdf forms which duplicate info then print them to sign?
Please bear in mind I'm a complete novice haha
Many Many Thanks in advance
Hello
SO far Iv'e got every book in the library watched every tutorial video and this is the first time Iv'e joined a forum so I'm pretty desperate to work this out!
I clicked on Access by accident one day and was curious and delighted Iv'e been playing around with it non stop and I'm a COMPLETE beginner but I'm really really stumped on the following...
I am using the student template database but wanted to change a few things.
I am a teacher and I get referrals of students I then interview them (if they show up) So I have created a table and form for referrals which tracks where they came from, contact info etc then if I accept them onto the course I want a check box or similar to then transport them into the main student list with more in depth info such as medical etc.
My problem is how to relate the two tables and if accepted duplicate some of the fields I already have for that person, if not accepted for them to remain on my referral list.
Is it possible once I have the database set up I can somehow fill in fields and get the database to autofill in paperwork pdf forms which duplicate info then print them to sign?
Please bear in mind I'm a complete novice haha
Many Many Thanks in advance