brucewin
Posts: 143
|
| Posted: 12/26/2005, 2:07 PM |
|
I have a search form (similiar to the employee directory example) with 2 list boxes that search for a department and a title. On the same page I have a the Employee Grid. If I delete a department or a title in the seperate lookup table, the reocrds that have the title or department in them no lonlger display in the grid for the employees.
I have to go into the database manually and add in a title or department that is not deleted to make it show up again.
I have been trying to make changes to the where statement in the grid, but am having not luck. Am I even in the right place?
Bruce
|
 |
 |
eserver221
|
| Posted: 12/26/2005, 4:34 PM |
|
It's about the join method you use, you can look at the corresponding XML file to find which method it use. INNER JOIN or EXTERNAL JOIN?
it is all about SQL.
|
|
|
|
|
