I am having difficulties designing a database with data from table 1 referencing multiple data in table 2. For example:

Table 1 includes:

id   Title

1    105MM   

2    155MM

Table 2 includes:

id    Country

1     BEL

2     CAN

3     FRA

4.    ITA

How do I design both Tables in order to link Table 1 with multiple records in Table 2?.

For example when I select 105MM, I want to see all the records from Table 2 that pertains to 105MM. I am trying to avoid duplicating the coutrires in table 2 just to link to the id column in table 1.

Output Example:

105MM
   - BEL
   - CAN
   - ITA

155MM
   - BEL
   - FRA
   - ITA

I think I need to add other columns in Tables 1 and 2 because if I only use the ID columns from both tables, I will only link to table 2 where the ID columns match in both tables. I want to be able to see multiple records in table 2 that applies to a record in table 1. For example when selecting 105MM in table 1, I want to see
BEL, CAN,ITA from tablle. Those same countries may also be linked with other titles in table 1.

Thanks,

Victor