A little help....

[The Rev]

OK. I am in "tweak mode" right now. 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. Each class expires on a different day for each person. I have everything I need except for adding a new member and deleting an old member. When I add a new member, I want it to propigate to my training list table with all the classes listed for the new user. Right now, I have to manually add all 33 classes (I cheated and just added the classID by numbers). It is a bit quirky. I want to automate the class additions. I also want to delete old members and their classes when they leave so as not to bulk up my reports. Thanks

 

[ColinEssex]

Hi

If your report is based on a query, why can you not exclude the members where the expiry date is not Null. Then you'll only get the "active" members in the report.

Col

 

[The Rev]

My request was unfortunately not based on a query. I am trying to design a form where I can add a new member with last name, first name social # (all added in my Members table) and it automatically pulls all classes from the Classes Table and puts them into the training table with all of the classes assigned to the new MemberID generated from Member table. Thanks for any help you can give