Alpha Video Training
Results 1 to 3 of 3

Thread: Lookups

  1. #1
    Norman Kagan
    Guest

    Default Lookups

    I have, what I thought is a simple problem, and any help will be greatly appreciated.

    Background. I have a bridge club. The database has, amongst other things, a members number as well as the members name. There is also a field for the members partner's name and number. The Bridge Federation does the scoring of each days sessions and submits the results to me in an Excel spreadsheet.

    I can import the members results with no problem, but I only have the partner's number. I want to lookup the partners NAME from the main database and AUTOMATICALLY fill the partners NAME into a field in the SESSION database where I have imported the results from the Excel spreadsheet.

    H-E-L-P please anybody!!

    Thanks
    Norman

  2. #2
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,656

    Default RE: Lookups

    Norman

    Your other option is to create a set that has both tables and connects via the partner's number.

    The set can have the name table as the parent and the session as the child.

    Some times I find that I need two sets. name - session and session - name. They both have functionality and may be needed.

    You'll have great flexibility by defining a set for your purposes.

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

    Default RE: Lookups

    Norman, instead of looking up the partner's name, you need to lookup the partner's number, and 'fill' the partner's name, don't you ? This can be done use a table lookup defined in field rules, I should think. Have you tried that? The field rules for the Session table, partners field, should use a table lookup back to the Members table, sorted on member number. Find the number for the partner, and fill the partner name.

    -- tom

Similar Threads

  1. Lookups
    By kvaughn@earthlink.net in forum Archived Wishlist
    Replies: 0
    Last Post: 07-04-2005, 10:37 PM
  2. Lookups
    By andymeer@yahoo.co.uk in forum Archived Wishlist
    Replies: 7
    Last Post: 07-01-2005, 11:13 PM
  3. Lookups
    By Ian Prime in forum Alpha Five Version 4
    Replies: 1
    Last Post: 09-19-2002, 05:48 AM
  4. Lookups
    By Edward F. Schulz in forum Alpha Five Version 4
    Replies: 8
    Last Post: 09-11-2002, 05:48 PM
  5. Lookups
    By Bob Whitaker in forum Alpha Five Version 4
    Replies: 1
    Last Post: 05-01-2002, 07:12 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
  •