Problem getting all data if using 2 search criteria

[geinel]

Row Number Par Act ID  ACIS No  Activity Date                        Prof ID 

1                  6Q7-CWH  102498      Feb 1, 2003 1:33:17 PM         
2                  6Q7-CWH                    Feb 1, 2003 1:33:17 PM  1012955   
3                  6Q7-CWH                                                            947154   
4                  6Q7-CWH                                                            999006   
5                  6Q7-CWH
6                  6Q7-CWJ   
7                  6Q7-CWN 
8                  6Q7-CWH     
COMMENTS:
 
Hi guys,
This is one call, but in the data it has populated as 8 rows but the par evt id is the same in all the rows. Par Evt Id is a ID generated by the sieble system. If I am quereing the report with one criteria which is ACIS NO "102498", it is giving me all 8 records, but if I am searching with ACIS NO "102498" as well as PROF ID "999006", it is not pulling any records because of the "and " operator i guess, it is searching ACIS NO and PROF ID in the same row, which is not there.  Ideally it should get all 8 rows in both the cases. In my child tabular model I have all the filters for prompt, in my Parent tabular model I have a filter par evt id = child tabular model. par evt id. So it can get all the records with same par evt id which is related to my search criteria lets say ASIC NO "102498".
So please let me know what should I do to get all the 8 rows in the cases where my search criteria has 2 or more filled prompts. As I am getting acurate data if I filled one prompt and search the data.   
Please help me as I am in deep trouble.   

Thankin You guys in advance.
Geinel

[bdybldr]

That's a messed up table.   I feel your pain!!! :'(  I would fix the format of the table if possible.  At least populate all rows with the ACIS No.  That would solve your problem.

Is the Prof ID always on the same line number?  If so you can set that criteria in the filter (RowNumber = 4), assuming you modify the table to populate ACIS No in all rows.

If you want to return all rows, why do you have to specify the Prof ID?  Also, I don't understand how all 8 rows are returned when only one row has the ACIS No.

Please provide more details.

[geinel]

Hi Thanks for understanding my pain. The format of the table cannot be fixed so that is out of question. I have grouped the ASIC NO in the report  but still some of the fields are empty in the database. No PROF ID could be any where and anyways PROF ID prompt should look for the par evt id which are present inACIS NO,  what we have to look in to is .......
 an example

select par evt id where activity date = ?DATEPARAMETER? and par evt id IN
select par evt id where product msg = ?PRODUCTMSGPARAMETER? and par evt id IN
select par evt id where prof id = ?PROF IS PARAMETER? and par evt id IN
select par evt id where ASIC NO = ?ACIS NO PARAMETER?

lets say we have 4 prompts...........but if we are using only three prompts like DATE, PROF ID and ACIS NO it should automatically drop the PROD MSG  sql

The search criteria could have 10 prompts also, actually if the user wants to know about the proffesional 
 you want to return all rows, why do you have to specify the Prof ID?  Also, I don't understand how all 8 rows are returned when only one row has the ACIS No.

[bdybldr]

geinel,
When you build your prompts always use the "EVT ID" instead of the prompt value.

for example,

When you create the Prof ID promp box, display the Prof ID to the user but use the EVT ID field for retrieving records.

Use this field for all prompts.

Sorry I'm not much help but I'm trying to come up with something.