I am writing a query.
One table has unique records with people's names and a unique number for each record, (i.e. Jane is 83, Mary is 72, John is 100)
One table has telephone numbers with a unique number for each record. (i.e. 1234567, 2223456)
But when I write an append query and refer to the value of the record (i.e. Jane, John, 1234567) instead of its primary key (i.e. 83 for Jane, 72 for Mary), I get a type mismatch error.
Is there a way I can just refer to the values of the records instead if its primary key? It would make the query a lot simpler if I could just refer to the value of the record instead of its key.
Thanks very much in advance.
One table has unique records with people's names and a unique number for each record, (i.e. Jane is 83, Mary is 72, John is 100)
One table has telephone numbers with a unique number for each record. (i.e. 1234567, 2223456)
But when I write an append query and refer to the value of the record (i.e. Jane, John, 1234567) instead of its primary key (i.e. 83 for Jane, 72 for Mary), I get a type mismatch error.
Is there a way I can just refer to the values of the records instead if its primary key? It would make the query a lot simpler if I could just refer to the value of the record instead of its key.
Thanks very much in advance.
