Results 1 to 3 of 3
  1. #1
    altotoe is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2012
    Posts
    4

    Novice seeking help with tables and combo box

    I am quite new at access. I have browsed the forum but no one of the cases seems to apply. I'll try to explain this as simply as possible (nothing is less comprehensible than an inexperienced operator...).
    I have two tables. The main one is MEETINGS and has several fields. Those I am talking about are country_name, country_supplier, and country_remarks. There is a second table, called COUNTRIES, with only four fields: ID, country, supplier, remarks. I have included a combo box in table MEETINGS to select the country from COUNTRIES table.
    Question: how can I fill the four fields in table MEETINGS with the value of the four fields in table COUNTRIES when the country_name and country fields match?
    Please note that the same country can have different suppliers (3 maximum, so I don't think it is worth to create another table). Data example follows.

    List example from table COUNTRIES
    ID | Country | Supplier | Remarks |
    1 | Belgium | BCF12 | Ref. Pierre |
    2 | Austria | AFE73 | Recall Thu |
    3 | Belgium | BRE45 | Good |

    When choosing record 3 in this table through the combo box in Form MEETINGS, records country_name, country_supplier, and country_remarks in table MEETINGS are populated with the corresponding values from table COUNTRIES.
    Should the two tables be related in any way? They have no common field and country field in table COUNTRIES has no unique values.
    Thank you for any assistance.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    You haven't really described "the business" that this database is going to support. However, my suggestion is to NOT start with -- "I have 2 tables". I'd suggest you write a 3-4 line description of what you are trying to do in plain English, then follow the approach in the article at this link.
    http://www.rogersaccesslibrary.com/T...lationship.zip

    And then post your refined questions and thoughts. Good luck.

  3. #3
    altotoe is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2012
    Posts
    4
    Quote Originally Posted by orange View Post
    You haven't really described "the business" that this database is going to support. However, my suggestion is to NOT start with -- "I have 2 tables". I'd suggest you write a 3-4 line description of what you are trying to do in plain English, then follow the approach in the article at this link.
    http://www.rogersaccesslibrary.com/T...lationship.zip

    And then post your refined questions and thoughts. Good luck.
    Well, I need to keep track of decisions taken during meetings. It is the virtualization of about 200 forms we have in paper format.
    But this adds nothing to my question. I think I cannot be more plain than I have been in my previous post.
    I have opened the file you suggest (thank you, anyway) but I am not completely sure it has anything to do with my question, which is about a simple procedure.

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

Similar Threads

  1. Replies: 3
    Last Post: 09-16-2011, 10:09 AM
  2. Form Combo Box assistance for Novice
    By piper in forum Forms
    Replies: 1
    Last Post: 04-22-2011, 12:53 AM
  3. Novice at best
    By jmorse in forum Reports
    Replies: 8
    Last Post: 04-19-2011, 03:21 PM
  4. Newbie seeking input
    By Bruzer in forum Access
    Replies: 1
    Last Post: 04-07-2010, 09:03 AM
  5. Seeking to pruduce rank by year
    By JLR in forum Queries
    Replies: 0
    Last Post: 01-21-2008, 06:10 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
  •  
Other Forums: Microsoft Office Forums