I am struggeling to make a relationship between these two tables in Access 2010.
To get the same value of the column on the first table I need to concentate two colums of the other one.
I have two tables.
Table "Orders"
"FirstnameSurname"
"John Smith"
"Tom Jensen"
Table "Costs"...