You did a great job.
What you want is peanuts, it's enough to format the color field as Edit Box instead of Drop-Down list and you're fine, you can insert 200 in find mode and Pantone 200 stuff will be found.
Actually all fields have the same value list - Category - get rid of it.
Thank you, Siplus.
How would I go about getting peanuts to work for this particular application. Like I said before I am really new to FMP. I also can't figure out how to get the category list to be off there.
go into layout mode,
open an inspector, (cmd-I)
click on a field, look in the inspector under the "Data" tab, section "Control style", select "Edit box" from the popup menu, rinse and repeat for other fields.
That did the trick. Thank you. As this thing evolves I will be on here more and more often asking questions. Thanks!