I made a view to show in a single table which are stored in two tables.
There is one same key field for each tables and the view has only sigle row for each keys.
There is no problem to see the data of that view in the other Database program, like HeidiSQL.
After add the view in one table preference windows and set table fields and form fields to see the data of the view.
But there is no content in the view fields.
Please help me..