Alpha Video Training
Results 1 to 2 of 2

Thread: problem with query on sets

  1. #1
    Member Graham Wickens's Avatar
    Real Name
    Graham Wickens
    Join Date
    Apr 2000
    Location
    Gloucestershire, UK
    Posts
    795

    Default problem with query on sets

    I have a set where the Parent Table is linked to the Child table by "one-to-many". How do I built a query that will return all Parent records that have Child records?

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

    Default RE: problem with query on sets

    Graham,

    I think the quickest solution would be to design a new set, inverting the order of your tables so that the child table becomes primary, and the primary table becomes the child, linked one to one.

    An alternative would be to write a script which steps through your original primary table one record at a time. As each is fetched the script would look to see if there are linked child records. If there are the primary table record would be marked. When all are processed a query could be run to show only the marked records.

    -- tom

Similar Threads

  1. Query Problem
    By Kevin McDuff in forum Alpha Five Version 5
    Replies: 3
    Last Post: 09-16-2003, 09:06 AM
  2. Query Problem
    By Jack Ripley in forum Alpha Five Version 5
    Replies: 9
    Last Post: 08-18-2003, 12:21 PM
  3. Problem with Tables and Sets
    By Todd Canipe in forum Alpha Five Version 5
    Replies: 1
    Last Post: 12-02-2002, 03:30 AM
  4. Problem with Tables and Sets for a Report
    By Todd Canipe in forum Alpha Five Version 4
    Replies: 1
    Last Post: 12-02-2002, 01:51 AM
  5. Query Problem
    By Joe Dempsey in forum Alpha Five Version 4
    Replies: 2
    Last Post: 11-07-2001, 03:06 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
  •