it gives me headaches

[unknown]

i have this database, thats suppose to have have there names and then have the values (satisfactory, unsatisfactory, needs improvement) put in a seprate table but be linked to there names ( i know that doesnt make much sence so just look at my database) I have two problems. First it doesnt save the values once the form is closed, so if im half way done entering information and close it i have to start over again, but the names are still there. Second is that the values arent linked to there names, everyone gets them all, which does me no good. I have tried everything i know how ( which isnt very much im still a beginner) to get this fixed. what am i doing wrong

 

[Jack Cowley]

You need to make some major changes... Here is a rough idea of what you need:

tblStudents
StudentID (PK and autonumber)
LastName
FirstName
...other fields...

tblWeeklyReport
WeeklyReportID (PK and autonumber)
StudentID (FK)
Skill
AccomplishmentID (FK)
DateOfReview
Comments

tblDegreeOfAccomplishment
AccomplishmentID (PK and autonumber)
AccomplishmentLevel

You really need to revise your current structure similar to the above. Also, do not use spaces in Field, Control, Table, etc., names and use standard naming conventions.

hth,
Jack

 

[scottfarcus]

Try this...

 

[Jack Cowley]

Scott -

My comment would be how would you easily add more items to the table "tblDailyReport"? Not allowing for the ability to easily add more items without changing the structure of the table is not good practice in my humble opinion.

Just my 2 cents worth...

Jack

 

[scottfarcus]

Jack,

I completely agree.