You can write a simple Query
ID, 'here you chose column with unique identifier for connection
[Column1]& "-" & [Column2] as SOMETHING 'Column1,Column2, etc are names of your columns
FROM [Name of your table]
Than you can make a relation if you wish.
That's just one the most simple example.