Check for a condition

[Charley]

Hi. I have a simple 3 Table DB.

Planning

Objects and

a Join Table JOIN_plan_obj

Those Objects are in fact People. People how won´t come to an event if there is her best Friend (the condition) also invited.

To shorten the whole thing an objekt has just 2 fields.

Name and Vorraussetzung (condition)

What I like to do is: If i choose Someone who has got a Condition Partner, which is not jet in the Join Table,i like to get at least an error massage that i have to invite that Person first.

A simple File is attached and Zipped.

I think first of all i need to fill in the Condition Fields for the Peoples with their Keys. And then start some kind of Loop.

But i cant get it work.

helpme.fp7.zip