Hi, Victor,
Just my 2 cents worth - I would probably make hidden fields in the original
data entry panel with formulas that break out the name into first and last, and
then make the panel links back and forth between the 2 panels on those hidden
fields, rather than the whole name field.
Laurie
----- Original Message -----
From: Victor Warner
To: Dataperfect Users Discussion Group
Sent: Monday, August 20, 2007 7:39 AM
Subject: Re: [Dataperf] Re: subfield function and creating a record in
anotherusing data link.
Ralph,
Thank you for the reply. I am not worried about the data entry (as only I
will be using the database). The field in the first panel is more of a display
name and can contain the name of companies.
As to your second point, you are right about the misdiscription of the panel
link but I just entered here for the purpose of an example.
However, what I am doing, is it achievable in the way I am doing it?
Victor Warner.
Ralph Alvy wrote:
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
------------------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
