I bet the problem is exactly what Tim says below. The only way I'd do it
differently from Tim is link the two panels with a numerical ID number
field. This way, if I later change
Smith, John James
to
Smith, Johnny James
I won't break the linkage. Of course you could always use Cascade Update to
guarantee the linkage remains intact, now that I think of it ... just some
thoughts.
Tim Rude wrote:
> Victor,
>
> It sounds like you're wanting to use the full name (Smith, John James) to
> link on, but then in the second panel you're wanting to change the
> contents of the linked field. If so, wouldn't that break the link?
>
> I think you need to have a matching field in both panels that holds the
> full name. Then in your second panel, separate out your last name, first
> name fields, etc. with the subfield[] formula.
>
> i.e.:
>
> P1F1 contains Smith, John James.
>
> P2F1 also contains Smith, John James (created through link from P1)
> P2F2 has formula: subfield[P2F1;",";1] to get the last name only
> P2F3 has another formula to extract the first name
>
> It sounds from your description like you're linking P1F1 directly to P2F2
> and then trying to manipulate P2F2's contents. I don't think that's going
> to be very successful. Or maybe I've just misunderstood your description.
>
> Tim Rude
>
> ----- Original Message -----
> From: "Victor Warner" <[EMAIL PROTECTED]>
> To: "Dataperfect Users Discussion Group"
> <[email protected]> Sent: Monday, August
> 20, 2007 8:39 AM Subject: [Dataperf] subfield function and creating a
> record in another usingdata link.
>
>
>> I would like to know if the following is possible:
>>
>> 1. I have two panels. The first panel contains a field ("MainField")
>> where I enter the name of a person in the following format:
>>
>> Smith, John James
>> Atberg, Mary Jane
>> etc
>>
>> 2. In the second panel I have contact details for the person with
>> separate fields for first name, last name and so on
>>
>> 3. I have created a data link from MainField in panel 1 to the last
>> name field in the second panel with Prompt Create set. I have tested it
>> and it works. Ie when typing in a name in the first panel a record is
>> created in the second panel.
>>
>> 4. In the second panel I have created the required panel link to the
>> first panel and in the last name field I have entered a subfield
>> function to use only the last name from "Smith, John James":
>>
>> subfield[P1F1;",";1]
>>
>> but it does not work. Whether with or without this function, I still get
>> "Smith, John James" in the second panel last name field.
>>
>> Is what I wish to do achievable and am I doing it in the right way?
>>
>> Help with this would be greatly appreciated.
>>
>> Victor Warner.
>> _______________________________________________
>> Dataperf mailing list
>> [email protected]
>> http://lists.dataperfect.nl/mailman/listinfo/dataperf
>>
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
