 |
|
| Browse | Ask | Answer | Search | Join/Login |
|
|
||||
|
Access Relationships
This is a repost from a previous question...
Sorry for being confusing... I have the many to many jx tbl working fine... I have attached a screenshot of my relationships so maybe I can ask a more understandable question. 1. I have a form to generate an event , recordsource is tblEventComplete. In the form I can select either a "training" or "Activation" by CBO(stored in event field.) 2. Then an "Activation" event can be a "Mutual aid" or "InstitutionalOperation" (Purple tables) , a "Training" event can be "Quarterly" or "Monthly" or "course training". Selected on second CBO on form. The choice is stored in the operation field of the eventcomplete table. 3. The details I need to store for each "operation" type are different. Details of those are in the red and purple highlighted tables respectively. 4. I have an attendance subform RecordSource is the jx table (tbleventattendance)(works fine)... The yellow tables are used for my cascading cbo's for event, operation, location... not sure if they even have to be related... they are just lookup tables. 5. My goal was to have a form to create an event (date time, Event) check off attendance(subform) and then be able to score only those individuals that attended that particular event based on the event type (training, activation) and their subgroups... Quarterly Training, Etc, with a nested subform form based on a query of the linked tables. I almost had it, but the query had outer joins and you cannot edit those... I found that out I cannot for the life of me get the relationships correct... I can picture in my head the order of events and how to store them... obviously not with good normalization/relationships. I am storing the information completely incorrectly... I truly thank you in advance for any more time you put into answering this question... Your time and patience is appreciated. (psI have only woked with access for about three months) Attached Images |
||||
Check out some similar questions!
New relationships
[ 27 Answers ]
When starting a new relationship, less then a month, how many times should you see each other/ call/ talk?
God in relationships
[ 1 Answers ]
I recently had a relationship conflict with someone who I have religious differences with... He is Christian and I do not believe in God. Although I do not believe in God, I do believe in religion. I want my kids to go to church (probably whatever religion my partner is) because I feel it would...
Can't access pop3, Pop3 access not working from my computer
[ 1 Answers ]
I have XP SP 2 - Its been about a week since any of my pop3 accounts have worked (Gawab, Gmail, Spymac, Toughguy). The error messages I am receiving on all of my pop3 accounts are similar to : The host 'pop.gawab.com' could not be found. Please verify that you have entered the server name...
View more questions Search
| Question Tools | Search this Question |
Add your answer here.
|
