On Tue, 22 Apr 2008 10:46:24 +0200, "Ursus" <ursus.kirk@[EMAIL PROTECTED]
>
wrote:
>>>>
>>>
>>>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
The table titles_lookup is another table occurance of titles. But now
that I understand your suggestion, I believe I see a way to implement
it. Thanks for clearing it up for me.
--
FW
|
