February 11, 200323 yr 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
February 12, 200323 yr 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
Create an account or sign in to comment