Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Jordan
    Posts
    137

    Angry Unanswered: Master Detail (Forms)

    Hi all

    I have table A which has fields (no, A1) and
    table B which has fields (a_no, sno, b1)
    in forms 6i I made master detail blocks for both (no = a_no),
    every record in A has many records in B

    the question is :
    I want to display only the records of A that have recordes in B with at least one value of B1 <> A1, without make view.


    thanx in advance

  2. #2
    Join Date
    Feb 2004
    Location
    Jordan
    Posts
    137

    Talking

    Its ok. I found the answer

    in block A I put the default WHREE CLAUSE :

    (no) in (select aa.no from a aa where
    (select count(*) from b a_no = aa.no and a1 <> b1) > 0)


    but is't little slow (cause of self join)

Posting Permissions

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