Filtering

sridhar

I have a List form to list the details of all the Depositors. But I want to show only the Depositors having a Particular ID(Where ID field is not a primary key).

Here I have to compare the ID field of Card Form "Deposit" and the ID field of the List Form "Depositor"

How I have to make it?

Regards,
N.Sridhar

admoretutsie

Are you filtering from code, or manually? If you are filtering manually, put the cursor in the filed you want (Depositor ID), and hit F7, then put the IDs you want to see (e.g 10|45|3001..6000).

I would be in a better position to help if you could explain your problem more rigourously.

Thanks

sridhar

I want ro do it in code. Please reply

N.Sridhar

kriki

Create a string with all the codes in seperated by '|'. EG '10000|20000|DEP001|DEP005'

use SETFILTER("The Field",txtTheString);

sridhar

I have a Card Form "Deposit Card". There I have fields like ID, Name.
I have a List Form "Depositor" that will be invoked when I click the lookup button of the "Name" field in the "Deposit Card" Form.
When the List form is invoked I should see only the details of "Depositor" whose ID matches with the ID in the "Deposit Card".

I have used the Setfilter function, but I m viewing all the Depositors details.

Is that I have to set any property?

N.Sridhar