Newbie question about cross-indexing

[a.conti]

Hi, sorry to post such a newbie question... I'm using FMP11

Let's say I have a table for shipping charges, three fields and a bunch of records, let's say:

Object name/Shipping charge within UK/Shipping charge worldwide

Object1/50£/100£

Object2/100£/200£

Object3/150£/300£

Now I'd like to create a form/table/portal/whatever to cross-index my customer's needs, so that I insert the object he wants and where he lives and I get the shipping charge.

Sorry again for the naive question, but I don't have a clue about what to look for. Thank you.

Alessandro

[Matthew F]

I'm assuming that "Object1/50£/100£" represents 3 different fields on a Shipping charges table.

My suggestion is to put a "Location" text or calculation field your customer layout which indicates whether this is a domestic or international shipment. You can then obtain the proper price in several different ways.

1) If you want to see the prices in real time (such that they will be subject to change every time the price changes) then create a relationship between the customer table and the price list table using the ObjectID as the match field. Then create a calculated field on your customer table with the effect of:

Price = if(Location = "Domestic" ; Shipping charge::Price1 ; Shipping charge::Price2).

2) If you want to generate a quote or an invoice with a fixed price you should do the calculation in a script or have a script copy this calculated field to an invoice table.