Auto Entry of Data

[DaveT]

I am building (trying to) a small database (Access 2000) for tracking
students and courses taken. I use 3 tables,
1. Student Details (Where Personal stuff is entered)
2. Course taken (The Course they are taking)
3. Modules Taken (The modules within each course - can be from 3-20)
Data entry is completed with forms.
When entering a new course for the student I enter their ID# and the course
they are taking in the "Course Taken Table". The "Student ID# + Course taken" gives me a
unique indentifier for the course which I enter to log the Modules taken in the "Modules Table" as they complete them. Can anyone please advise how after entering the
Student ID# (eg: "12345678") and the Course (eg: "ECDL") that the "Course
ID" field automatically updates to eg: "12345678ECDL" without having to
manually input it everytime? The "Course ID" Field is a unique key.
Any help would be welcome.

Thanks
Dave.

 

[Carol]

Instead of having a Course ID field set up in your tables, which is a combination of information already contained within 2 fields, set this up in a query. Have the recordsource for your form a query. In a empty field within that query, make a new field name called CourseID. Set this field to capture both the StudentID and the Course.
Example:
CourseID: [StudentID]&[Course]
This will add both numbers together and your form can now reference with field and it will be automatically updated.

Good luck.