Search results

Thanks for that MStef. It still has the problem in that I can't put in the same course twice i.e. same course title but different date done. My relationships musn't be right, I have a 1:m staff to course that I thought was OK.

I've been working on a database (attached) for a health trust. I think the relationships are right but I'm having a problem entering data. The subform shows the correct data but I can't figure out how to enter data using a form. Can someone point me to a tutorial - I have searched the forums...

Thanks Pat - beleive it or not I figured that out by looking at a few examples. I've now got a 1:n I'm highly pleased with myself!! I've attached the database and would be grateful if you would have a look at it. Earlier posts had suggested that I have a staff/courses/training done tables...

Hello. Recently posted for advice on building an access database on health service training. I had a lot of help but I suppose I haven't really grasped relationships yet. My database looks like this: tb_staff containing staff_id, first_name, last_name, base, dept_ward, job_title tb_courses...

Still having problems. Would someone take a look at the attached database and tell me where I'm going wrong? I'm not sure how to link a staff member to base/dept. Thanks.

Hello. I posted a while ago on a database I'm working on. Still having trouble with relations. These are the fields in 1nf: FNAME LNAME JOB_TITLE BASE DEPT_WARD COURSE DATE(S)_ATTENDED_COURSE COURSE_TRAINER(S) COURSE_VENUE CERTIFICATE_ISSUED The database keeps a record of various training...

Still haven't got my tables sorted yet. I'm using a spreadsheet example from microsoft that shows me how to go from raw data to 3nf but I'm not sure how to proceed. I've given staff a unique id but am not sure how to sort dept/base/course etc. I have A Employee_ID LNAME FNAME JOB_TITLE B...

Thanks for that Colin (and thanks to the others for their replies), I've also got base and department, are they treated the same as job title?

Hello. I'm new to databases and anything I know I've read up on. I know that relationships are essential so I'm trying to sort a database in ms access that I have inherited at work. It contains health service staff and their record of training - various training that they do regularly. I've...