How do i create a value list that will recognize each sales person ID and only pull their customers from that value list?
This is called a conditional value list and by using a relationship, the Sales person ID entered in one field can filter the values displayed in a value list for a second field.
Forum Tutorial: Custom Value List?
Knowledgebase article: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional%20value%20list
Demo File: https://www.dropbox.com/s/j6qf0z9fnem3uxd/ConditionalValueListDemo.fp7
Hierarchical Conditional Value lists: Conditional Value List Question
Feel free to post follow up questions here if those links aren't enough to get your value lists working correctly.
Retrieving data ...