Here’s my scenario and my request; I hope you can help me.

My organization does community outreach events, and I’m building an application to track them. When planning the event, we will use an “Add an Event” form, which will record the details onto two reports: a list of events, and a calendar. When the event is over, we will use a “Record an Outcome” form to record what happened at the event. (There is a lookup field in the “Record an Outcome” form, which lets you select any of the events that were added using the “Add an Event” form.)

To ensure that people record the outcome, I want to add a column to the List of Events report that displays a Yes or No value to show whether or not people have recorded the outcome for that event. (It would be even cooler to have a button or link for them to do so, but that can come later.)  I assume that means I have to:

1. create a field for that value in the Add an Event form – hidden from users on the form, but displayed as a column on the List of Events report,

2. create a variable to hold the value for that field,

3. default that variable’s value to No,

4. somehow update its value to Y when someone records an outcome for that event. 

Unfortunately, beyond Step 1, I do not have a clue how to do this. I know there must be some way that I would connect to the record, and the field, and assign a value to it... Can you advise?

I should add that I am not a programmer, so if you can explain it like I'm 5 years old, that would help. :-)