Need know how

[Daryl2106]

Hi,



I am developing a DB to track attendance and grades (see attached). Currently I have a sperate table for grades and attendance that are linked 0ne-to-one by the "ProgressKey" whic is the the class number combined wth the student ID number. The key is generated with an UD query to combine the two fields in the Student enrollment table.

Here are my questions

How can I combine the two fields (class number and ID) using an event immediately upon adding a new record?

How can I get a new record (with the newly created progress-key) to appear immediately in the attendance table as well?

Also, when I recoved my DB by exported the files to a new DB, I noticed three new tables linked in my relationships pane. it also insists on makinf a copy of my main contct information table in the pane???

Thanks in adavance for having a look.

Take care,

Daryl

[June7]

Recommend not using this 'ProgressKey' field. Use the Student and Class numbers as compound key or use the autonumber field as foriegn key. You have several autonumber fields set as primary key but then not using that value as foreign key.

StudentAttendance table has 4 fields named with a date. These are the only dates that attendance will be taken? This table has a 1-to-1 relationship with StudentEnrollment table. Every student will have a record in StudentAttendance? Might as well have the tables combined as one.

The only way I could get the ContactInformation relationship to fix was to copy the table with data, delete the original table (yes to remove relationships) then rename the copy.

[Daryl2106]

Thanks Jane. Great advice. I implimented the changes and everyhting is working fine.

Take care,

Daryl