From: Daintree F. <p.d...@xt...> - 2003-08-04 10:31:34
|
Excellent point Jerome! Thanks for pointing it out. Will think about how to deal with that one - your suggestion sounds like a good one. Previously, the search for a customer looked only for a customer irrespective of matching branch data. But users wanted to see the branches and really only searched by branches. Maybe an outer join might do it - all customer records irrespective of matching records in the CustBranch table. All contribtions gratefully received. Phil |