Please Help - Confused!!!

  • Thread starter Thread starter Anthony W.
  • Start date Start date
A

Anthony W.

I don't fully know how to explain this so please bare with
me. I have a database with three tables. Students,
schemes and qualifications. The students to schemes
tables have a one-to-many as does the schemes to
qualfications tables.

On my main form it shows details on a student. I have a
button on the form that when clicked will show the schemes
that relate to that learner.

On my scheme form i have a button that will show me
qualifications for that learner on that scheme.

When i go to the qualifications form i need a way to
sequentially numbering the records starting at one. It
needs to relate to a learner on a particular scheme.

For each qualification being undertaken, a new record is
added.

So if Mr X went on a Modern Apprenticeship and did a Level
3 NVQ in IT, the number of that record would be 1. If he
did another NVQ on that scheme the record number would be
2. If he went on to another scheme and did another NVQ
the record number would be 1 again.

I've thought about the way to word this too much now and
have confused myself.

If anyone can help me, or sort of point me in the right
direction it will be greatly appreciated.

Thanks in advance


Anthony Webb
 
Anthony,

I have a feeling, something like the DMax function may be
of help here - for example...

When you enter a new record, have the 'number' field
either default to

DMax("[Number]","[Qualifications]","Criteria") + 1

or set it using code.

Obviously you will need to check to see if any records
exist first, or DMax will be Null.

Not sure if this is exactly what you're looking for, but
if you look at DMax, I think this may be the place to
start.

John C
 
Back
Top