Victor Warner wrote:
> 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.
A couple of points...
1. Don't you worry about sloppy data entry in Panel 1? You're relying on the
data entry person entering the comma, etc. It seems to me to be safer to
have them enter Last Name, First Name, Middle Name in separate fields, and
let a formula in the another field join them if want.
2. subfield[P1F1;",";1] doesn't look right. The first argument should be a
field grabbed via a link. Something like this:
subfield[P2F10P1F1;",";1]
where P2F10 is the link that takes you to Panel 1.
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
