Sorting with drop down

[surge]

Hello,

I am quite new to using Filemaker Pro. I am currently imputing phone bill data for my company. I am using drop downs for two of my fields. The first is a drop down are all the vendors we use(example Verizon, At&t)which is being read from another table . The second field below it is the account number, which is also from another table.

How would I write a script for the account number so when I select a vendor, it would only drop down the account numbers for those vendors? For example, if I select Verizon from field 1 then all the account numbers will show and if I select At&t then all the account numbers will show. Thanks

[color:blue]Example below

Table 1

Record 1

Vendor: Verizon

Account # 1111

Record 2

Vendor: At&t

Account # 2222

Record 3

Vendor: Sprint

Account #: 3333

Record 4

Vendor: Verizon

Account #: 4444

Table 2 ([color:red]Help Needed)

Vendor : Vendor (drop down)

Account Number: Account number (drop down)

Edited March 29, 2007 by Guest

[mr_vodka]

What you are looking for is called a conditonal value list.

Conditional Value List

[surge]

Thanks for your help! I was able to finish the first portion. Now if I want to add another field that reads the account number and gives me the different cities do I go about this with the same conditional values?