Alpha Video Training
Results 1 to 3 of 3

Thread: Simple field rules query

  1. #1
    Member Nigel Wookey's Avatar
    Real Name
    Nigel Wookey
    Join Date
    Dec 2008
    Location
    Wiltshire, UK
    Posts
    26

    Default Simple field rules query

    I have a table listing each truck load of grain leaving my farm. So I have fields for date, description, haulier, truck registration, etc. How do I limit the drop down lookup list in the truck reg. field to display only those relevant to that particular haulier?

  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: Simple field rules query

    Table lookup in the field rules? Filter it.

    Discussed here.

    Basically you capture the haulier value to a variable and filter the lookup on that variable.
    There can be only one.

  3. #3
    Member Nigel Wookey's Avatar
    Real Name
    Nigel Wookey
    Join Date
    Dec 2008
    Location
    Wiltshire, UK
    Posts
    26

    Default Re: Simple field rules query

    Stan
    Thank you for your assistance. I have done as you suggested and it works well.

Similar Threads

  1. Puzzled by a simple Query.
    By gaby_h in forum Alpha Five Version 9 - Desktop Applications
    Replies: 2
    Last Post: 07-14-2009, 12:59 AM
  2. [Field Rules] Cannot input Simple mask
    By Maurice van 't Loo in forum Alpha Five Version 5
    Replies: 4
    Last Post: 02-25-2004, 04:02 PM
  3. Field Rules - "Simple List"
    By Aadkins101 in forum Alpha Five Version 5
    Replies: 3
    Last Post: 10-28-2002, 01:56 PM
  4. SIMPLE query
    By Ken Davis in forum Alpha Five Version 5
    Replies: 7
    Last Post: 10-22-2002, 06:36 PM
  5. Simple Query
    By Al Cole in forum Alpha Five Version 4
    Replies: 1
    Last Post: 09-04-2001, 09:22 AM

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
  •