Don,

Thank you for the reply. I do want copy a number of records in bulk.

The panel consists of the following relevant fields

Unique identifier
CD Number
Composer
Name of Piece
etc

If I obtain another recording of the same piece(s) of a composer, rather than having to enter all the details I would like to just copy the record with the compsoer/piece(s) details but with the new CD number.

I can see what to do about enter the fields in a report, but I am lost from that point (due to lack of knowledge) about how the new records(s) are created from the existing ones. Would you mind outlining the steps or pointing me in the right direction.

Victor Warner


On Fri, 21 Apr 2006 16:52:37 +0100, Don Friedman <[EMAIL PROTECTED]> wrote:

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



--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf

Reply via email to