Alpha Video Training
Results 1 to 2 of 2

Thread: complete novice lookup help

  1. #1
    Member
    Real Name
    Patrick Vance
    Join Date
    Jan 2007
    Posts
    1

    Default complete novice lookup help

    OK guys be gentle, I have several tables that share a comman filed a have named "case" in each form I have made this field a dropdown lookup and it dislpays each Case # that i have put in the parent table just like i planned. now the rub. when i select a case number in the pull down i want the form to populate with the record related to that case #. I have tried every action scipt that i even think would be relative and i cant get it to work. I am very new to this and i would greatly apreciate any help given. I hope i have posted this correctly. oops I am using alpha5 v8

  2. #2
    Volunteer Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Location
    Boston, MA
    Posts
    11,644

    Default Re: complete novice lookup help

    Quote Originally Posted by dopecop17 View Post
    OK guys be gentle, I have several tables that share a comman filed a have named "case" in each form I have made this field a dropdown lookup and it dislpays each Case # that i have put in the parent table just like i planned. now the rub. when i select a case number in the pull down i want the form to populate with the record related to that case #. I have tried every action scipt that i even think would be relative and i cant get it to work. I am very new to this and i would greatly apreciate any help given. I hope i have posted this correctly. oops I am using alpha5 v8

    If your lookup table (the parent table?) contains the data you wish to insert, all you do is add fields to the lookup definition in Field Rules. Thereby, you look up one record filling in multiple fields at one time. If the data comes form another table, then you do need xbasic (it can probably be done w. Action Scripting, too).

Similar Threads

  1. novice lookup
    By lemsco in forum Alpha Five Version 7
    Replies: 10
    Last Post: 01-23-2007, 12:02 AM
  2. Novice Question
    By fsinger in forum Alpha Five Version 7
    Replies: 12
    Last Post: 12-19-2005, 12:01 PM
  3. Novice needs help with xbasic.
    By Hesketh in forum Alpha Five Version 6
    Replies: 4
    Last Post: 11-23-2005, 03:04 AM
  4. Help for a novice user
    By Jeff Baskin in forum Alpha Five Version 6
    Replies: 4
    Last Post: 04-22-2005, 10:23 AM
  5. Menu creation - I'm a novice
    By Wanda Tucker in forum Alpha Five Version 4
    Replies: 9
    Last Post: 10-02-2001, 12:20 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
  •