I have a simple database with products and clients

There are then transaction records created when a client buys a product. I have the option to choose installation as yes or no.

At the moment i have a find which gets all the transactions where installation = yes and sorts them according to the transaction month. my script then goes on to a second find which has a drop down box of transaction month coming from the transaction table which they then select and results for that individual month come up rather then all of them.

At the moment it shows all the months from transactions in the second find from the pop-up list, even those where there is no installation for that month.

Any way to resolve this issue so only the months with transactions that have installation = yes comes up in the 2nd find in the pop-up list?

Thanks in advance,

Simon.

Why are you doing two finds? Why not have the user go to a find, enter the month (and year) that they are looking for, and choose either "yes" or "no" from the installation radio button on the find screen.

Yes but first of all i want it to show all the installations.

No point in having find for no installations because its the installations that the interest is in.

Is there a way in the script that u can pre-determine what will be in the month drop down list so it only shows the months where there are transactions where installation = yes?