There are 2 tables in a db. I'd like to search for a field which is in the detail table.
I've made a join query as it's written in PHPManual.
Search works fine, the 1st table finds the 2nd table's data. But.
I can't add/edit anything in the 1st table after the modification in the _add/_edit site. (I've added a join SQL in the 4th step). Duplicate field I think the error was in the browser. Anybody knows why? It's a bug?
I must decide between search and modify?
(Of course there is another way to solve my problem.
I filled the foreign key field with the data I needed from the 2nd table.
But that is not the best solution.)
Please write, if you can solve this problem.
Thanks