Alpha Video Training
Results 1 to 4 of 4

Thread: Normal method for SELECTING items in A5

  1. #1
    Member
    Real Name
    Mike D
    Join Date
    Nov 2008
    Posts
    88

    Default Normal method for SELECTING items in A5

    Hi

    I'm just wondering what is the usual method for selecting one item from many in Alpha 5.

    Say I have a large number of items, each with a unique identifier, what is the best way to search for records relevant to that item? In access I would create a form with a TextBox and just have the user enter what ever number he's searching for into it and then do a bit of checking to see that what the user has entered is in the correct format, then perform a search of the database for all references to that item, and bring up a list (on another form or report) that gives the info the user is looking for.
    i.e. I do not want the user to have to scroll through a long list of items and then select the one he/she is searching on, much easier if they can just enter the number of the item.

    Thanks for any pointers

    Mike

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Normal method for SELECTING items in A5

    Create an index on the desired field. Create a form (based on the table) with a button on it and whatever fields you want displayed. The button should use action scritpting to set the index and activate the Find by Key dialog.

  3. #3
    Member
    Real Name
    Mike D
    Join Date
    Nov 2008
    Posts
    88

    Default Re: Normal method for SELECTING items in A5

    Thanks Stan I think I get what you mean, I'll see if I can get it done.

    Mike

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Normal method for SELECTING items in A5

    Check the AlphaSports sample database for more elegant methods. Specifically the Customer Information form.

Similar Threads

  1. Cumulative Standard Normal Distribution
    By G Gabriel in forum Alpha Five Version 10 - Desktop Applications
    Replies: 51
    Last Post: 08-31-2011, 01:55 PM
  2. Insert Merge Fields in Detail View - lose row labels? Is this normal?
    By Chet Sapino in forum Application Server Version 10 - Web/Browser Applications
    Replies: 8
    Last Post: 03-12-2011, 03:53 PM
  3. Popup and Normal Forms - OnActivate
    By lcbarker in forum Alpha Five Version 7
    Replies: 5
    Last Post: 10-23-2006, 08:16 AM
  4. Newbie: Query - Update and Normal
    By MG in forum Alpha Five Version 5
    Replies: 2
    Last Post: 08-25-2004, 05:39 AM
  5. Math Function: Normal Distribution
    By kumargroup in forum Alpha Five Version 5
    Replies: 10
    Last Post: 08-24-2003, 09:08 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
  •