Hi Brian,
Actually, I sent them a file of my names, and they randomly chose 90%
of them and sent me the file back. Both files have a matching field in
the parent record (the Customer Number). I must find the proper parent
record first, then create a record through the panel link to record the
mailing because each record's unique ID number (not the customer
number) must be carried through the link. An auto-increment field is
also at work here when each mailing transaction is created. I'm not
sure that what you described will work.
Thanks.
Charlie
Brian Hancock wrote:
G'day Chucky,
I presume you have some way of
reliably identifying which customers received it? If so then there are
numerous ways you might be able to approach it.
On a report based on the Parent
panel, create a subreport to loop through the child records until you
find the one you want and then store some data away into a report
variable, (when looping through child field initialise the variable to
nothing in the report and not in the subreport header, and either only
write data into the variable if the variable is empty (eg assign RV99
with the formula: IF Rv99 = "" then blah blah ELSE RV99), or you might
be able to use formulas to set flags such as RV99 = RV99 OR
(FieldX=value) or alternatively set a flag and and then stop the
subreport when the appropriate record has been found. Just remember
to always initialise the flags before running the subreport.
Then when you exit the subreport you
are back to the main panel with information about the data you found,
or checking that the flag has been set, so you can populate the field
you want to update, eg set RV98 = IF RV99 THEN [value]
ELSE [oldfieldvalue] END, and save that variable to the field
Regards
Brian
-----
Original Message -----
Sent:
Wednesday, January 09, 2008 3:42 AM
Subject:
[Dataperf] Can this be done?
Hi Everybody, and Happy New Year!
I'm wondering if the following can be done.
My customer list in DP has a child panel in which I record what and
when I mail the customer promotional literature, catalogs, etc. I'm
currently involved in a test marketing program where I sent in a file
with a list of customers who were eligible to receive catalogs, and a
random 90% of those names were selected to receive a catalog. Now, I
want to record that mailing in my database.
There is a common data field. I
can't do it directly to the child panel, but must do it through the
main panel because a unique record ID is pulled through the link and a
transaction number is created. Can
this be using a merge/replace feature on in import where I then create
a record through the link?
Your thoughts are appreciated.
Thanks!
Charles Wolf
_______________________________________________
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
