If Statements or Loops?? Or both??? HELP!
I am using FM11.
Through some great help from this forum, my database has gone a long way! But now I have a dilemma that really has me against the ropes.
I am trying to have a field on the same layout, and from the same table, paste the most RECENT value entered from five other fields in ascending order.
To be specific, (and more clear)...if a person answers "YES" and then enters a number, and then the next three people answer "NO", (and don't enter anything else), I would like the next "YES" response to be pasted with the same value as the last "YES" response, while skipping over the previous "NO" responses.
Does that make more sense??? I need it to follow an order of succesion.