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?
A Ref in table A to table B, always contains the key of the target record in table B.
The key values in Table B uniquely identify each record in table B. By using the referenced tableโs key, the Ref ensures it can always find the right record in table B.
You can retrieve the value of a field in Record B using a De-reference expression. For example, if the Ref field in table A is called โMyRefToBโ and the wanted field in table B is called โMyDateFieldInBโ, then you might write
[MyRefToB].[MyDateFieldInB]
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |