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)
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)
