Anastacio Mirel
03-10-2003, 11:49 PM
I'm using FP 2002 and Access 97. I've created a simple data base table with the following fields: Tier, Zone, Wgt, & Rate. All are text fields except for Rate which is currency. The Wgt field is defined as follows: 100 to 499 lbs - 1; 500 to 999 = 2; and 1000 lbs and over = 3. The idea is to return the rate for a given tier, zone, and the actual weight of a package.
I've created the database reulsts page, and I'm able to input criteria and receive the results normally IF I provide a 1, 2, or 3 in the wgt field. I've written a JavaScript function to convert the acutal weight to a 1, 2, or 3 for use in the wgt field of my query.
This is where I'm running into a problem. I'm unable to pass the required value created by my function to the wgt field created by the DRW. I wioll then also need to retrieve the rate from the results talbe to use for further calculations.
I've a very limited knowledge of JavaScript and have been unable to find a olution. Is there a simple way to do this or can you refer me to a source?
Thank you in advance for your help.
I've created the database reulsts page, and I'm able to input criteria and receive the results normally IF I provide a 1, 2, or 3 in the wgt field. I've written a JavaScript function to convert the acutal weight to a 1, 2, or 3 for use in the wgt field of my query.
This is where I'm running into a problem. I'm unable to pass the required value created by my function to the wgt field created by the DRW. I wioll then also need to retrieve the rate from the results talbe to use for further calculations.
I've a very limited knowledge of JavaScript and have been unable to find a olution. Is there a simple way to do this or can you refer me to a source?
Thank you in advance for your help.