Help Please :)

I've got a field (ie- mark), and when data is entered into it, I want it to define what goes into another field (ie- grade).

the grade would be dependant on which subject was entered, and what mark was entered.

Any ideas? In very simpleton english, as I'm hopeless at Access?
Pretty please?

It is possible to do what you are wanting, but it isn't easy. It involves setting up a good database structure that help faciliate this action

Provide me with additional information and I can try to point you in the easiest direction

S-

What other information do you want to know?

I've got two forms, remark and subject, subject has in it the grade boundaries- but it would be ok to somehow hard code the values i needed in, rather than use the table. The remark table is linked to the subject table.

When a remark is entered, it should ideally, look at which subject has been entered in the remark form, and look at the new mark entered, to show a grade. to make it even more fun there's more than one subject, all with different grade boundaries...

Anything else you want to know?

Lets start with you table structure

Table Names, FieldNames, Sample Data, etc

S-

Ok, 4 tables in all:

Candidate
Subject
Centre
Remark

Candidate table fields: candidate#, centre no# (primary keys), candidate name

Subject fields: subjectcode (primary key), subject name, GradebounadyA, GradeBoundaryB, C, D, E.

Centre fields: centre number (primery key), centre name.

Remark fields: centre number, subject code, candidate number, date submitted, mark, grade.
With the ones in bold as primary keys linked from the other tables.

Sample data would be like:
Subject code 01325
Grade boundaries: a: 75, B: 67, C:60, D: 54, E: 48.
Candidate# 1234
Centre#: 12345

Is that ok?

Chari

Correct me if I am wrong, but you would really like to be able to enter the subject and mark and have the grade automatically be populated base on the range criteia in the subject table (which range may differ depending on the subject).

If this is the case look at the form1 on the Sample DB I attached

S-

Umm.. yes, thats it exactly. How'd you do that?

look at the code in the afterupdate event property of the txtmark text box.

You will have to use that code in you DB with modifications depending on table and field names in your DB, and textbox names on your form.

S-