Recent content by HBTCLaura

Hey, Thanks for your reply. This has been bugging me for weeks and typically as soon as I ask for help on here I figure it out! My solution: create another table tblLogin to keep login data; LogID (PK) Autonum EmpID (FK) StuID (FK) StaID (FK) LogPassword LogForm (name of the form the...

I have 3 tables to store information; --- tblStudent StuID (PK) Autonum StuName StuAddress etc --- tblEmployer EmpID (PK) Autonum EmpName EmpSite etc --- tblStaff StaID (PK) Autonum StaName StaJob When enquiring we enter the details of the student/employer/staff. If they want to take it...

Sorry, my tables didn't post as formatted! Please see below tblEmployer EmpID (PK) EmployerName EmployerAddress EmployerTelephone tblHealthandSafety HthID (PK) EmpID (FK) Last Review ELI Expriry tblVacancies VacID (PK) EmpID (FK) VacancyName VacancyStatus tblComments CmtID (PK)...

Hi, I have looked all over but can't seem to find anyone else that's having the same problem as me! I have the below tables which are all linked using EmpID tblEmployer tblHealthandSafety tblVacancies tblComments EmpID (PK) HthID (PK)...

Thanks for your idea's. Sorry if I seem a little dim, but, as far as I can see your set up would show the attendance records by person. Is there anyway to show them by Class? I kind of imagined it to look like the attached, where the subform is filled by a query based on...

Thanks for replying! I have done as you suggested and I think I have relationships right? (see attached screenshot) I've tried playing around with putting it onto forms and entering data but can't seem to get it to work. Sorry for being so needy, I like doing these sorts of logical...

Hi, I have 3 tables as listed below: tblClassDate ClassDateID (PK) ClassDate tblStudents StudentID (PK) FirstName Surname tblAttendance AttendanceID (PK) StudentID ClassDateID AttendanceAM1 AttendanceAM2 AttendancePM1 AttendancePM2 I have created a form frmClassDate based on...

Hi all, I have a database that logs all of our company contacts, for the ease of use this is viewed as a form displaying the company details at the top and two subforms (one showing contact details and the other showing a commentry of conversations with said company) To save the user from...