How do I validate a field by keeing a certain value from repeating in a found set?
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!