Results 1 to 2 of 2
  1. 12-03-2013, 02:31 PM #1
    lasts3cond
    lasts3cond is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2013
    Posts
    2

    Lookup Wizard for 2 different tables?

    Hello, I need help with my assignment. My instructions are to create a lookup field and select ReservationID, CheckinDate, Guestlastname, Guestlastname. Problem is ReservationID, CheckinDate are in tblReservationID and Guestlastname, Guestlastname are in tblGuests. Is it possible for lookup wizard to work with 2 different tables? I cant see to get it to work.
    Reply With Quote Reply With Quote
  2. 12-03-2013, 03:02 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,644
    The lookup will have to be a query that joins the two tables.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Is using the Lookup Wizard for tables a bad idea?
    By Foxglove in forum Database Design
    Replies: 8
    Last Post: 07-24-2013, 12:21 PM
  2. LOOKUP WIZARD, is it possible?
    By finsmith in forum Programming
    Replies: 5
    Last Post: 01-24-2013, 09:45 AM
  3. lookup wizard
    By dafdek in forum Access
    Replies: 1
    Last Post: 01-10-2013, 04:57 PM
  4. lookup wizard
    By bigmac in forum Access
    Replies: 1
    Last Post: 03-10-2012, 02:09 PM
  5. Lookup wizard
    By VLI in forum Forms
    Replies: 7
    Last Post: 01-28-2011, 09:25 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums