Hi. I’m trying to link two tables, something I’ve done before with no problem.
In each table I have a column named Project. After choosing the ‘Ref’ column type I make sure that the table is
linking to the other table then cross my fingers that it connects to the right column. Normally it does so, presumably based on matching the column names. In this case both are called ‘project’ and so there should be no problems.
However, it insists in matching to the ‘Key’ column (see below).
Can anyone tell me what I’m doing wrong?