AnsweredAssumed Answered

How do I validate a field by keeing a certain value from repeating in a found set?

Question asked by hgscn on Aug 14, 2011
Latest reply on Aug 16, 2011 by philmodjunk

Title

How do I validate a field by keeing a certain value from repeating in a found set?

Post

Hello friends,

I need your help:

I have a student table (one) related to a host families table(many). There is a Host Family Status field in the Host Families table, with "Current" and "Canceled" as its vaules. For each student, there can be several Canceled host families, but there should always be ONLY ONE "Current" host family. SO when I enter a new "Current" host family for a certain student, I want the database to remind me I have a current host family already and so I should mark that as Canceled first.

 

How could I do this?

 

I would appreciate it!

Outcomes