I need to be able to insert a price based on the contents of 3 fields. Field one is client. Field two is type. Field three is Format. (Type refers to a Tape Dub Type such as Edit, OTO Edit, Dub). (Format refers to a tape size such as VHS, DVD, BSP, 1"). We have 30+ clients, 4 Types, and 8 Formats).

Each client has their own pricing based on what is being done and onto what format it is being copied.

See attached PDF file for tables and relationships. (The main page is called BDV, the rest are look up tables).

If I enter client XXX on the BDV Page, select the Dub_Type and the Format from pulldown menus, I need to have the correct price fill in.

Relationships.pdf

You should have a record in your pricing table for each Client-Type-Format combination. This means 30x4x8 records, and fields: Price, Client_Code, Type, and Format. Use a relationship that uses all three keys to pull the correct price.

Thanks - the brain just wasn't working.

This is the answer I was looking for.