I am a complete newbie to FM. I have managed to write a DB for my Bushfire Consultancy. I am trying to automate the use of matrix tables which are used to analyse bushfire risk. There are four criteria which are used in these matrix tables to produce a Bushfire Attack Level (BAL) which is the output. There are six different BALs’: BAL-LOW, BAL-12.5, BAL-19, BAL-29, BAL-40 and BAL-FZ

The variable criteria are:

- FDI, a figure which relates to the geographic location. There are four of these which deems there are four matrix tables.
- Vegetation type, there are seven different types to choose from: Forest, Woodland, Scrub etc,
- Slope, There are 5 different slope groups: Flat land-0 degrees, 0-5 degrees, 5-10 degrees, 10-15 degrees and 15-20 degrees
- Separation distance, this is a user defined number based on a site measurement.

I have a form called ‘Site_Data’ which has dropdown boxes for FDI, Vegetation type and Slope parameters while the Separation distance is entered manually.

I have been trying, without any success, to write a calculation which will produce the appropriate BAL once all the criteria has been entered into the form. At first I was trying to use an if statement but after considerable research I believe a Case statement is probably a better way to approach this. A couple of examples of the criteria and the BAL output would look tike this:

FDI=100, Vegetation=Forest, Slope=Flat land-0 degrees, Distance=19, therefore BAL=BAL-FZ

FDI=100, Vegetation=Woodland, Slope=0-5 degrees, Distance=29, therefore BAL=BAL-19

Any help or advice is gratefully accepted.

Cheers

In your BAL calculation put a case statement like this :-

Case (

FDI= 100 andVegetation= "Forest" andSlope= "Flat land-0 degrees" andDistance= 19 ; "BAL-FZ";FDI= 100 andVegetation= "Woodland" andSlope= "0.5 degrees" andDistance= 29 ; "BAL-19")

If you want to add another statement just put a ; at the end of the last statement and follow the format.

NOTE you will probably have to substitute the bold text for you're field names.