Hi, Victor,
Sorry I'm kind of late to the game, so maybe you've already got a solution to
this. Just in case not, I believe you can cause a record to be created in
Panel 2 ONLY when you want it to by doing the following: Make a hidden numeric
field in Panel 1 with a formula that puts a 1 in it if flag field contains an
"I" but a 0 if your flag field contains a "C." Then make this hidden field in
Panel 1 keep a total in another hidden field in Panel 2. This should only
create a record in Panel 2 when the flag is "I."
Laurie
----- Original Message -----
From: Victor Warner
To: Dataperfect Users Discussion Group
Sent: Thursday, August 23, 2007 11:58 AM
Subject: Re: [Dataperf] Re: Re: subfield function and creating a
recordinanotherusing data link.
Ralph,
Thank you very much for these suggestions. Unfortunately none seem to do
quite what I want. However, without them automatically creating the record, and
use of the subfield function in the relevant records in the subpanel I get
almost all that I wanted.
Victor Warner
Ralph Alvy wrote:
Ralph Alvy wrote:
Victor Warner wrote:
Thank you for the responses and pointing out the error of my ways! I can
see now clearly where I was going wrong.
Having clarified my thinking I have a related question which I would
appreciate some help with following:
Panel 1 contains a number of fields including: A field to capture the
name of the client which can be an individual or a company, and another
field which is a flag field and which is either a "I" or "C" (format A1).
In a second panel I will have a name field (among other fields, which I
will be using the subfield function).
What I would like to do in Panel 1 is that if I enter a name in the name
field and an "I" in the flag field then a record is created in the
second panel, putting the name in the name field. But if I type a name
and "C" in the flag field then no record is created in the second panel.
Trying a combination of data links and If statements does not seem to do
it. Help with this would be greatly appreciated.
Another possibility:
An Exception List Index, which is placed in the Panel Link Field List, that
excludes all records with 'C' in the Flag Field.
_______________________________________________
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
