How do I get the correct information?

[Robbydobbs]

I have 3 files which are Vehicle, Products and Fees.

The first file is the Vehicle file which consists of 5 fields. They are Vehicle ID, Category, Type, Make and Model. They make up a conditional value list in the Products File. Category from this file also populates a field in the Fees file.

The Second file is the Products file which includes the conditional value list described above along with the Customer ID number.

The Third file is the Fees file which consists of 4 fields which include the Fee Id, Customer ID, Category (which is populated by the Vehicle file), and Fee. Now the Fee is dependent upon the Customer ID and Category. (The Customer ID is generated from a file of it

[Pupiweb]

Create a calc field, CustID & Category in the Fee file

Create a calc field, CustID & Category in the Products file

Relate this field in Products to ita analogous in Fee

Set the Fee field in Products to be a lookup of ThisRelationship::Fee

HTH

[Robbydobbs]

You're the greatest. This worked perfectly. THANK YOU VERY MUCH.