I have a query,I have repeating fields called ship to city,freight code & shipping rate.

I want to select a shipping rate from another file which has freight code,shipping rate and

Ship to city.

The freight code for the first file is looked up from a third file and stored.How will I set

a relation which will get me the shipping rate when the freight code is entered and ship to

city is selected.I don't want to change to portal as many calculations are already set.

To perform a lookup or create a relationship based upon two fields, city and freight code, you need to create what we call a composite key. This is a combination of city and freight code. This could be:

Key(calculation, text, indexed) = city & freight code

This composite key is created in both files and used to create the relationship.

-bd

Thanx but when setting realtions with calculation fields it doesn't work.

That is because the relation is set using calculation field it doesn't work and if we copy and paste to a text fileld and set the relation it works,so the problem is not still solved as I have repeating fields and copy and paste doesn't work with repeating fields.

I AM SORRY IT WORKS AS I HAD SET THE CALCULATION RESULT TO NUMBER INSTEAD OF TEXT!!!

THANX