Create a dropdown list based on your parts db then select the Auto-Complete using value list.
You can also customise your dropdown list to show records (parts) from a selected category then use the Auto-complete setting.
Home > Designing and creating databases > Editing objects on layouts > Formatting and setting up field objects in Layout mode >
Setting up a field to auto-complete during data entrySetting up a field to auto-complete during data entryYou can set up a field to use auto-complete (type ahead) to help users quickly enter values inor . FileMaker makes suggestions based on what the user has previously entered into the field, or based on values in a value list.You can use auto-complete on text fields displayed as:•Edit boxes•Drop-down lists•Drop-down calendars
Using a Self-Join Relationship to Perform an Exact Match Find
Answer ID: 3176Last Updated: Dec 03, 2011
You may find these demo files of interest. Feel free to ask questions after examining them if you can't figure out how they work:
Demo file with both auto-complete enabled value list that looks of ID numbers and several "search" portals with differing filtering techniques. Can be converted to .fmp12 by opening from the file menu:
Demo file that just looks up the ID using auto-complete enabled name based value list. Simpler than drop down list in first demo file: