Hi,
I created a custom view like that:
SELECT
OS.PKID,
OS.Numero,
OS.[Dt Abertura],
OS.Clientes_Codigo,
Cadastro.Telefone
FROM OS
INNER JOIN Cadastro ON OS.Clientes_Codigo = Cadastro.Codigo
ORDER BY OS.[Dt Abertura] DESC
The idea is show the client phone in the list page using the client_codigo (codigo is the id).
When I try to add a new record a receive this error msg:
"odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement contains the following unknown field name: 'OS.Numero'. Make sure you have typed the name correctly, and try the operation again., SQL state S0022 in SQLExecDirect"
The fiel Cadastro.Telefone is not selected in the add page and only appears in the list page but still I get the error.
How can I correct this?
Tks in advance.
