Dave Reyes
New Member
Hi. I am trying to do a free form query for a browse and I've been having a problem.
I have joined multiple tables in it and it seems to be working fine, but when one of the table's record is not found, the browse will not display the record even if there are records from the other tables.
To be more precise, I have table1,table2,table3 as tables with record1,record2,record3 as a fields of the tables respectively.
If table3.record3 is not available, the browse will also not display table1.record1 and table2.record2 on the browse.
Is there something I did wrong or I need to do?
I have joined multiple tables in it and it seems to be working fine, but when one of the table's record is not found, the browse will not display the record even if there are records from the other tables.
To be more precise, I have table1,table2,table3 as tables with record1,record2,record3 as a fields of the tables respectively.
If table3.record3 is not available, the browse will also not display table1.record1 and table2.record2 on the browse.
Is there something I did wrong or I need to do?
Last edited: