Hi team. I have five tables relating. The first table is tblParticipant(ParticipantID - not auto number, PartipantName, ParticipantSex) the second table is tblTraining(TrainingID - auto number, ParticipantID, TrainingTypeID, TrainingTopicID, AppearanceID, TrainingStartDate, TrainingEndDate, TrainingVenue) the third table is tblTrainingType(TrainingTypeID, TrainingType), table four tblTrainingTopic(TrainingTopicID, TrainingTopic) and table five is tblAppearance(AppearanceID, Appearance).
The relationships: These table are related as per colors above, the files with same color in two tables are related.
My request. When Doing data entry in the form to populate data in the tblTraining I want Appearance field in the tblAppearance auto change the values from First, Second, Third and so forth.
Explanation: I am developing a Training database which will store a list of teachers who will be trained for three years, each teacher will attend many training. So when she/he comes for the first training when I Choose the Training Type, the table generate the new TrainingTypeID and when I choose a training topic generate the new TrainingID.
Request: I want the field Appearance to auto change the field from blank to First when I enter the training type for the first time, and when the participant attend the second training the Appearance field also auto update to Second, and so forth. What is the appropriate code or way to perform this task
Will appreciate much your help