Novice seeking help with tables and combo box

[altotoe]

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.

[orange]

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.

[altotoe]

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.