AnsweredAssumed Answered

If Statements or Loops?? Or both???  HELP!

Question asked by user14830 on Jun 22, 2010
Latest reply on Jun 22, 2010 by philmodjunk

Title

If Statements or Loops?? Or both???  HELP!

Post

Hello again!!

 

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.

 

PLEASE HELP!

Outcomes