Search results

Has anyone else ever manged find a free/simple way to link to website to return address details from a postcode? I am creating a database for a school and similarly do not want to spend any money. In addition they will only really need a small post code local, but access to this type of...

Er, depends on the pupil :eek: But seriously, many thank for this. I will need to actually build it to see it working. I'm not hot on the SQL syntax. So let me get this straight. In the junction table I want to add a new record that will combine a class with a pupil (which is what I...

Doc the Man, I'm posting back here because no matter how I think about this, it seems to come back to the same problem. I cannot figure out how I would "join" class sets to pupils in the manner that I want. If all pupils are contained within a table, we could say that an attribute of the pupil...

Many thanks the Doc the Man, lagbolt and others that have pointed a direction for this project. What started out to be a quick "knock up" has seemingly turned into a bit of a mammoth task. Still I have attempted to look at the entities I wish to model and have to break down everthing as far as...

The Doc Man and Lagbolt, I thank you for you informed comments. Although I have studied relational databases and understand the basics of normalisation, putting this into practice if have always found difficult. It is clear that I needed to remap the entire project and formailse what I wanted to...

Things are never quite as simple as they appear! Indeed, the concept of our Form is close to your Grade, but the similarities do not continue. The form year a child is in, in the UK is defined by their age and nothing else. A 15 year old child could never turn up to school but would more than...

Lagbolt, Many thanks for the input. I have at least firmed up some "do's and don'ts" of what I need to do. I will restructure the table as such. It was mentioned elsewhere that graduation year would be preferable to intake year (i.e. what happens if a kid joins from another school), but the math...

I had thought about calculating schooling year from "actual year - current year". However, the schooling year span two actual years, so the current Year 7 will be in the 2006 intake year and finish in 2007. Buy putting the years into a table I thought it would be easier to then write code so at...

Hi, I have a fairly simple database that looks like the attached. It is the beginnings of a school database. Unfortunately, the MS template doesn't quite do it. We have around 700 pupils in 5 year groups. Each year's intake is assigned the year of that intake (e.g. 2002, 2003 etc). The...