ADV SEARCH IN 2 TABLES

Hi,
you can do the following:

• create custom view on the Datasource tables tab,
  
• join your tables for this view on theEdit SQL query tab
  
• and check off fields from two tables on the advanced search on the Choose fieldstab.

Hi,

• create custom view on the Datasource tables tab,
  
• join your tables for this view on theEdit SQL query tab
  
• and check off fields from two tables on the advanced search on the Choose fieldstab.

hi,

if I create a custom view ... I must use "advanced search" of this new "table" .... right??

Example

I have the table A that is joined to table B e C....

The Advanced Search of table A must consider also the fields of table B e table C ....

If I create a new Custom View ... I create table D, right ??

I have tried ....

I have done as you have explained to me ... but I have used the principal table (the table A)...

The table A has 1 record

Table B has 2 records (table link properties = Left Outer Join with table A)

Table C ha 2 records (table link properties = Left outer join with table A)

I believed that in this way was ok .... but I was wrong. ...

Infact in LIST of table A I find 4 records instead 1 record ...

and I don't know how do !!!!
Can you help me??

It's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.