Victor,

If I understand things correctly you essentially want to "copy" a
record and create a new record with a different/new catalogue number.
I don't know if you intend to do this in bulk or in on an individual
basis but for starters here's what I'd do.

Basically what you want to do is write a report that includes every
real field in the panel. save it, go in and adjust the catalog number
to a new number and then import that record in to the panel; it will
save as a new record because it has a unique catalog number. I don't
know how you issue catalog numbers but there are a number of ways you
could keep a panel with just new/unused catalog numbers and pull that
number from there - or you could automatically increment that catalog
number in the panel.

Does this help at all?

If you were a bit more masterful at all of this - which will come in
time - you could actually create a new record from the old one through
a link which is in essence the same thing. The tricky part is getting
that update catalog number. I'd start with the more cumbersome method
and work from there.

Don

On 4/21/06, Victor Warner <[EMAIL PROTECTED]> wrote:
> Rich,
>
>
> Thank you Rich, you are right about there being a unique identifier (which
> there is separate to the catelogue number).
>
> Being still at a relatively beginning level in understanding DataPerfect I
> am not clear on the steps I need to take with the report to achieve what I
> set out below. I would appreicate some help with these steps.
>
> Victor Warner
>
> On Fri, 21 Apr 2006 13:45:44 +0100, Rich Bragonje <[EMAIL PROTECTED]> wrote:
>
> > Hi Victor,
> >
> > At 05:25 AM 4/21/2006 , you wrote:
> >> I would like to know if it is possible in DataPerfect to do the
> >> following:
> >>
> >> 1. A panel contains records which share the same catalogue number.
> >
> > Unless the catalogue number, or some other unique identifier is present,
> > and is
> > used in the index, the new record will be rejected as a duplicate.
> >
> >> 2. I wish to create new records which are duplicates of existing
> >> records but
> >> the only field that is to change is the catalogue number.
> >
> > This will work as long as the catalogue number is used in each index.
> >
> >> 3. Whether it is possible to create a report which can copy all the
> >> required
> >> records (selected by catalogue number), create new records with the data
> >> from the required records and insert the new catalogue number.
> >
> > This should be relatively easy, as long as the new catalogue number is
> > automatically generated.
> >
> >
> >> I would appreciate help with this.
> >>
> >> Victor Warner
> >
> >
> > Rich
> >
>
>
>
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
> _______________________________________________
> Dataperf mailing list
> [email protected]
> http://lists.dataperfect.nl/mailman/listinfo/dataperf
>


--
Don Friedman
ProfessionalRecords.Com LLC
PRS Data Systems
205 S Main Street
Pittsburgh, PA   15215
412-784-1600 - 1-800-PRS-FILE
412-784-1615 Fax
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf

Reply via email to