The Rev
Registered User.
- Local time
- Today, 14:00
- Joined
- Jan 15, 2003
- Messages
- 119
I have 3 tables. One table is for classes. I have each class assigned to a ClassID. The second table has Members assigned to a MemberID. The third table is my training list table. I tied the Member ID and ClassID to expiration dates in the Training table. Each class expires on a different day for each person. I have everything I need except for a form for adding new members. When I add a new member, I want it to propigate to my training list table (which I already have been able to do) but with all the ClassIDs listed with the new MemberID. Right now, I have to manually add all 33 classes (I cheated and now just add the classID by the autonumbers my Class table generated). It is a bit quirky. I want to automate the class additions. Any ideas? Many thanks!!
