Create Unique Index On Multiple Fields

[Warren Kuhl]

I actually figured it out...just concat both of the fields in the method.
Everything is working great now.

Warren

On Sun, Nov 21, 2010 at 12:29 PM, Warren Kuhl <warrenkuhl at gmail.com> wrote:

> Ruslan,
>
> I am on the 'create field or method' box.  I selected VarChar with a unique
> flag.  I assume I click the Method radio button.  In the text box, what is
> the syntax to combine two fields?
>
> Warren
>
>   On Sun, Nov 21, 2010 at 12:07 PM, Warren Kuhl <warrenkuhl at gmail.com>wrote:
>
>> Ruslan,
>>
>> Thanks....I will give this a try.  Thanks again for your help!
>>
>> Warren
>>
>>   On Sun, Nov 21, 2010 at 11:52 AM, Ruslan Zasukhin <
>> ruslan_zasukhin at valentina-db.com> wrote:
>>
>>>  On 11/21/10 5:51 PM, "Warren Kuhl" <warrenkuhl at gmail.com> wrote:
>>>
>>> > I am trying to create a unique index on two fields (both fields
>>> together have
>>> > to be unique).  How do I do this in Valentina Studio.  I see how to
>>> make each
>>> > field unique...just not sure how to combine them.
>>>
>>> Hi Waren,
>>>
>>> You can solve this task in Valentina using very powerful concept
>>>    Table Methods
>>>
>>> Also known as calculated field in FileMaker.
>>>
>>>
>>> In WIKI exists description of all this ideas.
>>>
>>> In short, you create method in the same way as a field in table.
>>> Then you define some Expression on that 2 fields.
>>> Then mark METHOD field to be indexed and unique.
>>>
>>>
>>> --
>>> Best regards,
>>>
>>> Ruslan Zasukhin
>>> VP Engineering and New Technology
>>> Paradigma Software, Inc
>>>
>>> Valentina - Joining Worlds of Information
>>> http://www.paradigmasoft.com
>>>
>>> [I feel the need: the need for speed]
>>>
>>>
>>> _______________________________________________
>>> Valentina mailing list
>>> Valentina at lists.macserve.net
>>> http://lists.macserve.net/mailman/listinfo/valentina
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20101121/3c4e091c/attachment.htm>