Subject SearchPanel Problem with Same Field Name
Author Jeff Clement
Hi there,

I have a problem with the SearchPanel in IBO which concerns
having two field names with the same name, but from different
tables using a join.

ie.
SELECT table1.code, table2.code
FROM table1
LEFT OUTER JOIN table2 ON table1.id = table2.id

The SearchPanel displays the two field labels correctly, but the two
edit boxes would be both related to table1.code.

I would have rathered use aliases in my select statement but I get
an error when I try to post my search. So instead I tried using the
full field name (as above) and I have the problem with the edit
boxes in the SearchPanel both relating to the first field which share
the same field name, but the field labels which I configured to
display different names display correctly.

Can anyone offer any suggestions? Am I going about my problem
the wrong way?

I hope soneone can help.

Thanks,

Jeff.