Sure. Go ahead and post it.Thank you theDBguy. May I share the DB with you here so that we can discuss?
Ah, before I do that, I would like to mention that storing calculated values is against normalization rules, so we tend to recommend not doing it.@theDBguy, please download attached file for your kind reference.
What I wanted to achieve is in the EventParticipants form after adding the records in the Event Participants subform, the fields 9.a) and 9.b) will be auto filled based on the counts in the subform and be stored in the Events table.
How do I achieve this? Thank you for your help.
The "correct" way to avoid the error is to "not let any user manually enter anything." Since the value can be calculated, it should just be calculated anytime you need it. To do this, you can use a query for your form or report where you can include a calculated column, so you can display the accurate information to the user.Got your point. The intention to have this was to lower chances of error of leaving 9.a and 9.b fields as blanks if entered manually like it is now.
Hi. I'm glad you asked. Please check out the attached modified version of your db.How? Sorry for my question but I am a novice in this field
Hi. You're very welcome. Arnel and I were happy to assist. Good luck with your project.@theDBguy, much appreciated. thank you for your guidance. Now have solved as we wanted. Thank you.
@arenlgp, thank you very much for a different approach to the problem.
Thank you very much to both of you