Alpha Video Training
Results 1 to 2 of 2

Thread: Duplicate records matches child link

  1. #1
    Member
    Real Name
    Bert Rapp
    Join Date
    Apr 2003
    Posts
    12

    Default Duplicate records matches child link

    Alpha Five V3
    Parent = cash transactions
    Child = traffic, indexed and linked by date to cash transactions, one to many
    If I want to print the current record, the number of duplicate records will equal the number of traffic records for that date. How do I get away from this?
    Thanks

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,310

    Default

    Don't know about A5v3, but in A5v4 the repetition of field values from the current parent table record (once each time for as many child table records as are linked to that parent record) is normal. This is how "composite" records actually appear to Alpha Five.

    The solution in A5v4 is to design a report layout. Insert a group break on the primary key in the parent table. Put parent table fields in the group header region. Put child table fields in the group details region. Since the header gets printed only once for each "group" the repetition is neatly avoided.

    Hope this helps you with A5v3. -- tom

Similar Threads

  1. Duplicate records
    By Elson Als in forum Upgrading to Alpha Five from Alpha Four
    Replies: 1
    Last Post: 04-15-2005, 05:18 AM
  2. Duplicate parent/child record
    By James Nickel in forum Alpha Five Version 6
    Replies: 8
    Last Post: 09-14-2004, 07:12 AM
  3. parent child link failure
    By Camille Venners in forum Alpha Five Version 5
    Replies: 2
    Last Post: 04-08-2003, 05:28 AM
  4. Editing of child db in multiple 1 to many link set
    By Al Bronson in forum Alpha Four Version 6 and Prior
    Replies: 0
    Last Post: 12-29-2000, 01:22 PM
  5. Duplicate records
    By Kenneth Cameron in forum Alpha Five Version 4
    Replies: 8
    Last Post: 04-12-2000, 06:00 PM

Bookmarks

Posting Permissions

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