Del_Piero_3
Registered User.
- Local time
- Today, 23:32
- Joined
- Jul 20, 2004
- Messages
- 33
Hi guys,
I am trying to do something but not sure how to code it, I would be grateful if someone can help me.
A slide is examined three times by three different members - so you get three results for one slide. If the results from each staff for that slide don’t match then it needs panel review (joint decision by three staff).
Basically I need the database to count when the three results have been entered and if they don’t match (compare “Result” field with each record with same slide number) then bring up “frm_CasePanelResults” to enter the panel result and append to that slide.
I think I need after update event procedure, but not sure how to start the coding
I have attached the relationship diagram, might make more sense. Thanks.
I am trying to do something but not sure how to code it, I would be grateful if someone can help me.
A slide is examined three times by three different members - so you get three results for one slide. If the results from each staff for that slide don’t match then it needs panel review (joint decision by three staff).
Basically I need the database to count when the three results have been entered and if they don’t match (compare “Result” field with each record with same slide number) then bring up “frm_CasePanelResults” to enter the panel result and append to that slide.
I think I need after update event procedure, but not sure how to start the coding
I have attached the relationship diagram, might make more sense. Thanks.
