I've set up the following db
tblstudents
PupilID_PK
Names etc
MathsClass
(This tbl is updated from a school systems DB)
Another table tblclasses is created from tblstudents by a create table query
tblclasses contains
classID
Maths class
DefaultMaths Tier
So I Now wish to allow users to set the Tier of entry for their next exam
My starting idea
The f values are an unbound field (which uses a Dlookup) are for foundation tiers which I'd like staff to be easily able to change to H (higher) should they wish.
The continuous form wont allow one button to change only one row in a continuous form.
Any suggestions of a way forward (or a completely different direction would be welcome)