HTH, Jens K. Suessmeyer.
"My form" is not really descriptive enough. Is this a tool issue? Or a SQL issue with code you have written to support a form?
If it is SQL, can you post some of the table structures? If it is the former, I would probably suggest you use profiler to get a view of the queries being sent and try to match that to what you expect to happen.