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


Example below

Table 1

  Record 1              Record 2           Record 3

Vendor: Verizon      Vendor: At&t       Vendor: Sprint
Account #: 33333     Account #: 44444   Account #: 555555


Table 2 (Help)

Vendor :   Vendor (drop down)
Account Number:  Account number (drop down)