Question: I am trying to create a select query in access with two tables I want to link/create a relationship.

Normally, if both tables contains same value you can just "drag" and create a link between those two columns.

In this case however, the second table have an " /CUSTOMER" added at the end in the fields.

Example;
Table1.OrderNumber contains order numbers which always contains 10 characters

Table2.Refference contains same order numbers, but will have a " /CUSTOMER" added to the end.

Can I link/create a relationship between these two in a Query? And how?

Thanks for the help!
Sebastian

Answer: 
This would not be allowed if the initializer is `static`, since the value needs to be assigned before the program executes. From C99:

> 
> All the expressions in an initializer for an object that has static storage duration shall be constant expressions or string literals.
> 
> 
> 

Otherwise, each initializer needs to be an "assignment-expression" or, in other words, a valid expression that can be assigned to an object.

So yes, this is legal in C.
Well, yes. The array is being initialized as it should which can be tested by printing it.

The array is also being sent to the function properly as p returns 6. However, do note that you are making a new array to send to the function.