Pre-query
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Pre-query

  1. #1
    Join Date
    Jun 2001
    Posts
    7
    Hi,
    Am having a master-detail relation btn a master block and a detail block.......Master block has a composite Primary Key. Can i Pass two conditions in Pre-Query to execute my query i.e. to fetch all the detail records....Passing one condition works in Pre-Query......If i pass two conditions it doesn't work.......
    Is there any other way to fetch the detail records besides using Cursor ?? I want to know if it is possible use Pre-query to execute the detail records when two conditions r passed.....Do let me know pl.

    Bala.

  2. #2
    Join Date
    May 2001
    Posts
    70
    I normally use the POST-QUERY. It seems to cause me less pain.

    Can you supply an example of the one condition and two condition so we can help suggest a solution.

  3. #3
    Join Date
    Oct 2000
    Posts
    90
    Unless I'm getting the wrong end of the stick, all you have to do is create a Relationship between the two blocks and Forms will create all the functionality itself. You can have more than one field when defining a relationship.

Posting Permissions

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



Click Here to Expand Forum to Full Width