Alpha DevCon 2018
Results 1 to 6 of 6

Thread: Fill fields with table lookup

  1. #1
    Member
    Real Name
    DON TRUDEAU
    Join Date
    Jan 2011
    Posts
    12

    Default Fill fields with table lookup

    I am trying to convert my old clipper application to A5.
    I have created my customer entry screen.
    In my old prg, I would enter the customer's phone number and do a lookup on the customer data file. If the phone number was found, the prg. would fill in the customers info, saving retyping. How can I do this in A5?

  2. #2
    Member
    Real Name
    Paul Tompert
    Join Date
    Apr 2009
    Posts
    33

    Default Re: Fill fields with table lookup

    If you go to field rules, you will see a tab that says lookups. Go to that choose table lookup. Now fill in the table & field that you need to do the lookup. Below that is a box that says SOURCE FILL DISPLAY. Source would be your lookup info and fill is for the table to be filled. Display is for your lookup screen. Hope this helps

  3. #3
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    24,832

    Default Re: Fill fields with table lookup

    There can be only one.

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

    Default Re: Fill fields with table lookup

    Time spent perusing the User's Guide will pay big dividends.

    -- tom

  5. #5
    Member
    Real Name
    DON TRUDEAU
    Join Date
    Jan 2011
    Posts
    12

    Default Re: Fill fields with table lookup

    I am trying to create what I think is a pretty basic application to keep track of customers and invoices. I wrote this app in dBase (clipper) a long time ago. So I know the layout of what I want to do. Just have to get A5 to do it. I will keep reading.
    Are there sample code examples for something like this ,that I can examine online?
    I am just doing one step at a time trying to get one form functioning the way I want. I think it works best for me to learn A5.
    I have 2 tables right now, customer & invoice. I linked the two using a ID field and indexed on the phone. I want to type in the phone number and if the customer is in the table, fill in the address info, then add the invoice info to create a complete record of the job.
    I can get it to fill in with just the customer table, but not the set-table. Nothing happens when I type in a known phone number in the set.
    I think I need some function or code to just display the customer info without actually adding him to the table if he exists, and then just enter the invoice info. Otherwise I will just keep creating duplicates in the customer table.
    I hope I have explained this clearly. Any guidance would be appreciated. This is harder than I thought it would be :(
    Thanks for the help
    Don

  6. #6
    Member The Mage's Avatar
    Real Name
    William McGowen
    Join Date
    Jul 2010
    Location
    Nebraska
    Posts
    287

    Default Re: Fill fields with table lookup

    If you don't know about these videos, they do help:

    http://news.alphasoftware.com/v10preview/videos.htm

Similar Threads

  1. Lookup and fill field from fields
    By nlok888 in forum Application Server Version 10 - Web/Browser Applications
    Replies: 3
    Last Post: 09-11-2010, 07:54 PM
  2. Lookup and Fill-Fields Action Javascript
    By Toby Locke in forum Application Server Version 10 - Web/Browser Applications
    Replies: 1
    Last Post: 01-15-2010, 02:23 PM
  3. Is lookup the right choice to select & fill fields with 2 fields
    By MikeData in forum Alpha Five Version 9 - Desktop Applications
    Replies: 13
    Last Post: 01-10-2009, 04:21 PM
  4. A5, V4.5, do not fill all the fields in table lookup
    By jrtarrago in forum Alpha Five Version 4
    Replies: 3
    Last Post: 11-10-2008, 03:08 PM
  5. Lookup table and fields to fill
    By rleunis in forum Alpha Five Version 6
    Replies: 1
    Last Post: 09-16-2005, 03:13 AM

Posting Permissions

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