AnsweredAssumed Answered

Setting up a quote system for trucking

Question asked by ohioguy48 on May 18, 2009
Latest reply on May 18, 2009 by philmodjunk

Title

Setting up a quote system for trucking

Post

Hello all,

 

...I'm trying to set up a quote system within Filemaker 10.  I've downloaded a trial version of the software to test its features and the ease of use.  Here is my problem.

 

I'm trying to set up a quote system which would allow me to pick from a "table" the values set forth and dropped into a row on the form. Here is an example.

 

 

(Accesesorials)  -  Private Escorts

 

Ohio

 

 

Line Item                  Description           Quanity                 Cost         Extented cost.    Total

Line Item                  Description           Quanity                 Cost         Extented cost.    Total

(as many as 10 rows or more from above).

 

 

Indiana

 

Line Item                  Description           Quanity                 Cost         Extented cost.    Total

Line Item                  Description           Quanity                 Cost         Extented cost.    Total

(as many as 10 rows or more from above).

 

 

What would be the best way to create this type of database?  My thinking is to create a "table" for each state due to the different charges/rates that each state bills. (or would it be better to have one table) listing (all the states) and there related chargers for each item.

 

example table:

 

Description               Cost

 

Oh-Permits               $40

Oh-Pole Car             $100

 

OR

 

Oh-Permits               $40

Oh-Pole Car             $100

IN-Permits                $50$

IN-Pole Car              $90

 

When you click on a line item, you would enter the value for each item.  When you get to the the "description" field, a box would pop up listing either one "table" for each state,  and then enter the item from the state/list,  OR one "table"  with all the states included in the search.  I've played with filemaker somewhat to which it allows you to enter part of a phrase, and the  list is shortened based upon your search. After entering a value (on one line) I'd want filemaker to insert another blank line for input. etc.

 

I think you get  the picture.

 

In the near future there would be more catagories (accessorials) added to the database, upon having other values listed for those as well.

 

Your help would be greatly appreciated.  Im somewhat familiar with an older version of FM, Version 5.  Please advise.

 

   thanks,

 

        Jeff

Outcomes