Hi all.
In my company we have a database to keep record of measuring and control instruments f.e. Pressure switchs, Thermometres, Gauges, etc.
Each type of instrument has a different form because the type of data we keep from them varies depending of how it works. Al these forms have a common part where we put the name of the instrument, the facility, serial number, etc. and a different one with the especific technical data for each instrument. We have a corresponding report for each type of form.
To enter data for a new instrument it's easy, the user just selects the type and then he is showed the right form.
The problem is when I want to print all the instruments data from a certain installation, for example. The query will give me as a result many different instruments. When I print the reports I need to launch a different one depending of the instrument type and here is where I need your help.
How to lauch different reports from a single query depending on the intrument type?
If I didn't explain correctly please let me know and I will try to make it clearer. As you surely have seen english is not my first language. :)
Thanks in advance.