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.