<div>
<div class="content wysiwyg-content">
I have a table in Filemaker &nbsp;HHStaff in this table there are hundreds of records of which only a set amount are active, i have a form that i need to populate a dropdown from &nbsp;and then have it go to that record, but i want the drop down to reference Employee ID but only populate the records that are Active. &nbsp;All of the above mentioned items are in the same table.<br />
<br />
The reason being i don't want to have to scroll through 1800 records in the dropdown box when only 150 of them are active.<br />
<br />
thanks in Advance
</div>
</div>


I have a table in Filemaker  HHStaff in this table there are hundreds of records of which only a set amount are active, i have a form that i need to populate a dropdown from  and then have it go to that record, but i want the drop down to reference Employee ID but only populate the records that are Active.  All of the above mentioned items are in the same table.

The reason being i don't want to have to scroll through 1800 records in the dropdown box when only 150 of them are active.

thanks in Advance

Conditional Drop Down List Filemaker Pro 12

I have a table in Filemaker  HHStaff in this table there are hundreds of records of which only a set amount are active, i have a form that i need to populate a dropdown from  and then have it go to that record, but i want the drop down to reference Employee ID but only populate the records that are Active.  All of the above mentioned items are in the same table.

The reason being i don&#39;t want to have to scroll through 1800 records in the dropdown box when only 150 of them are active.

thanks in Advance

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.

FileMaker Pro

Programs written for the Apple operating systems are distinguished from software created for other operating systems in that it must be approved by Apple for use on its devices, whether it is from Apple (Final Cut, iWork, Keynote, Logic Pro and GarageBand are popular titles), or is a third party application from Parallels, Nuance, Microsoft and Amazon, among many others.

Apple Software

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.