So if you select 9/3/2013, you want to see a value list from just those records where a date field also has 9/3/2013? We call that a conditional value list. Here are a few links on the subject:
There's a lot of overlap between the first two links so you can read one and skim the other. The demo file gives you several examples of different conditional value lists so you can examine them to see how they are set up. If you are using FileMaker 12, you can open this demo file from your File menu to get a converted copy of the demo file that you can examine in FileMaker 12.
The last link discusses how to set up a chain of conditional value lists where the value selected in each conditional value list controls the values listed in the next value list.
Forum Tutorial: Custom Value List?
Knowledgebase article: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional%20value%20list
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.
Actually I don't think thats exactly waht I want. I want to be able to make a drop down list of Date that when i select a specific date from that list, it shows me a list of records that have that date value. I can't figure out how to set this up as this drop down list is just a modifiable field currently. I want to be able to just select dates and then only see records for those dates. 1 date area, select the date I want, then see a list of recordsthat all were made on that date.
There are two approaches that list records for that date (instead of values in the value list).
- Use a portal where the date field where you select a date is one of the match fields.
- Make the drop down list field a global date field and then use a script trigger to perform a script that finds your records. Here's a thread of scripted find examples that you may find useful: Scripted Find Examples