Results 1 to 4 of 4
  1. #1
    ernestsnaith is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jul 2016
    Posts
    2

    Multiple lookup using same table

    I have a table ‘tblConnections’ that records connections between two equipment items and includes fields called ‘EquipA_ID’ and ‘EquipB_ID’. I have another table called ‘tblEquipment’ that is used to record the descriptions of equipment against equipment IDs.



    I have created a form which includes comboboxes for ‘EquipA_ID’ and ‘EquipB_ID’ and I have also added two other text boxes that I would like to display the equipment descriptions for the respective IDs referencing the single ‘tblEquipment’ table.

    How do I achieve this?

  2. #2
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    You're almost there. Having two combo boxes referencing the same table isn't usually much of an issue.

    Just set the control source for one text box to =[combo_A].columns(1) and the other to =[combo_B].columns(1).

    Which column you use from the combo boxes will depend on you you have them set up. The description you want to put in the text boxes does have to be in the SQL for the combo's, even if you don't display it in the combo itself (column width = 0.0). What do you show in the combo's and what is the bound column?

  3. #3
    ernestsnaith is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jul 2016
    Posts
    2
    Excellent, thanks for push in right direction.

    Note: One minor correction I believe .column(1) rather than .column(1).

  4. #4
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Note: One minor correction I believe .column(1) rather than .column(1).
    Thank you - I make that mistake all the time. Making an 's' of myself, you might say.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Selecting multiple elements from a lookup table
    By JRohde in forum SharePoint
    Replies: 1
    Last Post: 11-10-2015, 12:21 PM
  2. Replies: 5
    Last Post: 06-25-2014, 09:19 AM
  3. Replies: 8
    Last Post: 03-22-2012, 08:48 AM
  4. Replies: 2
    Last Post: 02-20-2012, 10:18 PM
  5. Multiple fields to the same Lookup Table
    By igooba in forum Database Design
    Replies: 9
    Last Post: 01-03-2012, 04:14 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums