Selection/filter forms

[Kerri Storr]

Hi,

I have inherited a database which uses the same selection / filter form to open various dataforms. For example, select a product type, which loads a form containing a list of products.

Copies of this form have been used in several places, with the target form referencing the search form in it's data query i.e.

- select * from tbl_products where product_type = frm_search.product_type

All these search form copies are taking up space.

Is there a way I can use only 1 search form, and maybe read in where the form was loaded from, and use that value to open the target form?

I'm sure it's possible but I've never done this before.

 

[afloyd]

Yes, you should be able to remove the copies of the search form. There are several steps you need to take:

1. identify which of copies you will use as the "one" search form and also the underlying query.

2. on the target forms change the "copy of search form" reference to the "search form name"

3. change all the triggers that opened the copies of the search form to only open the selected search form.

4. test

5. delete the copies

I hope you can make sense of this.

-Al