Re: Re: validation scripting

>>>
>>
>>FW,
>>
>>Since the values pre-exist, you could easily check if a value was used
>>through the relation****p with the function isvalid(titles::t_id ;
>>titles_lookup::t_idv). Returns True when the relation****p is valid (The
>>value already exists). You could also create a calculated field in one
of
>>the tables, with the same calculation and check that value with an IF. 
>>Both
>>solutions have the same result.
>>
>>You don't need any hagling with values in ValueLists, this would be
>>***bersome at best.
>>
>>Keep well, Ursus
>
> Ursus,
>
> I'm sure I missed something -- however the
> "isvalid(titles::t_id ; titles_lookup::t_idv)"
> syntax isn't correct for the IsValid function.  Is there a self-join
> or something implied here?
>
> thanks
>
> -- 

Implied was a relation****p between titles and titles_lookup. Since you use

the suffix _lookup I thought you already had one defined here.

Keep well, Ursus