Hello Everyone:
Happy New Year
I have a form that has a field Opportunity type. This field is a combo box and has 2 values-- Active and Retired. Right now I just have one form, which contains all the records, i.e. both Active and Retired. What I want to do is to create 2 more forms. One form will show only the records where the Opportunity type is Active and the other only the records where it is Retired.
What is the right way of doing it?
I tried to build a query and added the criteria as “Active”. But the problem that I am having here is that this form is based on 4 tables, which has one-to-many relationship. Due to this it’s displaying same information many times.
I also tried filter by form. It works fine. But when I close the form and open it again the filter disappears. Is there a way to save the filter?
Which of the 2 is a better way of doing this or is there any other way?
Thx in advance
Ekta.
Happy New Year
I have a form that has a field Opportunity type. This field is a combo box and has 2 values-- Active and Retired. Right now I just have one form, which contains all the records, i.e. both Active and Retired. What I want to do is to create 2 more forms. One form will show only the records where the Opportunity type is Active and the other only the records where it is Retired.
What is the right way of doing it?
I tried to build a query and added the criteria as “Active”. But the problem that I am having here is that this form is based on 4 tables, which has one-to-many relationship. Due to this it’s displaying same information many times.
I also tried filter by form. It works fine. But when I close the form and open it again the filter disappears. Is there a way to save the filter?
Which of the 2 is a better way of doing this or is there any other way?
Thx in advance
Ekta.
