SeedCode Support Forum

I bring in my orders electronically via EDI and drop them into a FileMaker database for order tracking purposes. One of the processes we do everyday is decide what orders will be shipped by courier and what orders will be mailed by Canada Post. The orders are generally low dollar value. I want to set up a shipping table that will compare the first three digits of the postal code in the main order table to the first three digits in the shipping table and bring in the shipping cost from the shipping table for that particular order. We can then let the FileMaker program calculate the shipping cost as a percentage of the total invoice cost and decide what orders will be mailed or which will be couriered. The postal code is six digits (eg L3R 3K2). Only the first three digits will be in the shipping table along with the cost. I hope this make sense. How should I set up the shipping table for the postal codes and the costs and I would I do the query. Any help would be greatly appreciated.