Alpha Video Training
Results 1 to 3 of 3

Thread: How to duplicate selected records in a Set?

  1. #1
    Tim Fitz-Randolph

    Default How to duplicate selected records in a Set?

    Might someone help me with this? Or where to look? How can I duplicate records in a Set simply? I am a Home Builder and use A5 to track materials for each house we build. When I begin a new house that is the same as another house in my database, I would like to duplicate that particular set of a couple dozen Material Schedules, but assigning it a new house Project_id.
    The Set is: Schedule----Schedule_items.

    As an example: I create two Copy Operations to copy first Schedule and then Schedule_items Where Project_id ="Monet". Then manually change Project_id to "Matisse". Then I must execute two Append Operations(parent and child)back to the Schedule Set. A5 is great and has proven incredibly powerful for me, but I am early in the learning curve. Any suggestions?

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Bowling Green, KY

    Default RE: How to duplicate selected records in a Set?

    It would help if you attached a copy of your set with only a few records but....

    It seems as if you could merely duplicate your set...highlight set name, right click, duplicate. Then use an update operation to change all the references from one client to the other. (Assign constant value).

    I assume you have some dates in the "schedule" set that need to be reset to "blank". These could be handled by the same update operation.

    If you need more details you'll have to provide more details.

  3. #3
    Real Name
    Aaron Strickland
    Join Date
    Jun 2000

    Default RE: How to duplicate selected records in a Set?

    There is a good article on Dr. Wayne's website,, dated 6-11-98, Duplicate a Set's Entries that would probably help you.

Similar Threads

  1. Posting Selected Records
    By Allen Krause in forum Alpha Five Version 6
    Replies: 1
    Last Post: 04-16-2005, 03:03 PM
  2. Appending selected records
    By catfish_pete in forum Alpha Five Version 5
    Replies: 4
    Last Post: 01-21-2004, 03:55 AM
  3. Where did "Use Currently Selected Records&quo
    By Dale Stansbery in forum Alpha Five Version 5
    Replies: 4
    Last Post: 10-22-2003, 07:36 PM
  4. Append Selected Records Too Slow
    By fgpylant in forum Alpha Five Version 4
    Replies: 1
    Last Post: 09-13-2002, 10:24 PM
  5. Printing Selected Records
    By Warren Guillory in forum Alpha Four Version 6 and Prior
    Replies: 4
    Last Post: 12-26-2000, 01:06 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts