1:1 Relationship

Hello, 

Say I have a table as follows:

Index No      Cost

1                    10

2                    20

3                    30

4                    40

I have another table as follows:

Index No      Remarks

1                      AA

2                      BB

I have created a 1:1 relationship via the index no column. I now want to merge the tables so that there's a remarks column for each index number. If the index number has a remark then the remark shows otherwise the row is left empty.