AceJupiter
MIS
Hi guys,
This relationship is more confusing than the DNA Paternity Test special on the Jerry Springer Show! (errr...don't have me shot for that lame joke hehe)
My application tracks, among a bazzillion other things, training for various members of my company.
After much research I've discovered that the training a member must get is tied to his/her TITLE. So each TITLE has a list of classes that each member must complete to be qualified for his TITLE (for example, a forklift operator must have the licenses for various types of forklifts, must have safety training etc). I think it is danged complicated, but it gets worse.
So each TITLE has a list of classes that must be completed, as we've discussed. I must intelligently tell Access which TRAINING each TITLE must accomplish. I think I need a many-many between tblTITLE and tblTRAINING. So far so good. Now, each MEMBER must be tracked according to his progress going through said classes.
Say there is member named Bob who is a DRIVER. I have a tblMember that is keyed to tblTITLE through titleID.
What I need to tell Access is "Okay Access, Bob is a DRIVER. Please look up which TRAINING DRIVERs require. Display those on a subform of our data entry form. We need to record which classes Bob has taken, enter the dates etc."
Can anyone help? I have this application humming as far as the classes all employees have to take. I am replacing a CRAZY Excel application which is so darned delicate...what the creator did was hand-type all the classes each member takes. So, if the curriculum changes, we'd have to go through this mile-long spreadsheet and hope to gosh we didn't mess it up. It's one of those deals with hard-coded formulae -- it's just a nightmare to maintain.
Many thanks for any assistance.!! I'm more than desperate enough to put up a file somewhere if anyone needs to see my table structure in order to help. It beggars my ability to describe clearly.
--ACE
This relationship is more confusing than the DNA Paternity Test special on the Jerry Springer Show! (errr...don't have me shot for that lame joke hehe)
My application tracks, among a bazzillion other things, training for various members of my company.
After much research I've discovered that the training a member must get is tied to his/her TITLE. So each TITLE has a list of classes that each member must complete to be qualified for his TITLE (for example, a forklift operator must have the licenses for various types of forklifts, must have safety training etc). I think it is danged complicated, but it gets worse.
So each TITLE has a list of classes that must be completed, as we've discussed. I must intelligently tell Access which TRAINING each TITLE must accomplish. I think I need a many-many between tblTITLE and tblTRAINING. So far so good. Now, each MEMBER must be tracked according to his progress going through said classes.
Say there is member named Bob who is a DRIVER. I have a tblMember that is keyed to tblTITLE through titleID.
What I need to tell Access is "Okay Access, Bob is a DRIVER. Please look up which TRAINING DRIVERs require. Display those on a subform of our data entry form. We need to record which classes Bob has taken, enter the dates etc."
Can anyone help? I have this application humming as far as the classes all employees have to take. I am replacing a CRAZY Excel application which is so darned delicate...what the creator did was hand-type all the classes each member takes. So, if the curriculum changes, we'd have to go through this mile-long spreadsheet and hope to gosh we didn't mess it up. It's one of those deals with hard-coded formulae -- it's just a nightmare to maintain.
Many thanks for any assistance.!! I'm more than desperate enough to put up a file somewhere if anyone needs to see my table structure in order to help. It beggars my ability to describe clearly.
--ACE