Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    40

    Unanswered: Particular Record found?

    i created two canvases, login and details.
    once the user name & password fields are enetered in the login canvas, it searches the details canvas to see if the record exisit and if it does, it shows that particular record!
    Wats the sql code or how do i do that?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Two canvases, you say? One or two blocks?

    If it is one block, write a POST-CHANGE trigger on, umm, username field (I'd prefer some kind of a hidden ID field though) which will populate fields on your second canvas.

    If there are two blocks, I'd suggest you to use master-detail relationship. The simpliest way to do this is using the Data Block Wizard (you have to have both blocks created already).

Posting Permissions

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