I do not understand why people need to use a value list for your invoices just to get to the latest invoice posted. Can you explain, from User perspective, what they are doing and why they need the last invoice posted? Also please, how are your invoice numbers created and what FM version are you using?
I am using FM11 Advanced and the reason for the value list is to create a user/invoice list. The database itself works perfictly as does the relateted table set,I want to limit the list to the current day and not to list invoices going back prior to that time frame. For date 6/1/2011, 20 invoices keyed to buyers are created. The next day 15 are created. I just need the option to limit the length of time covered by the list. Thats all I need to do. Thank you for responding.
PS, I looked at conditional formating but don't know if that is the best way to adjust the lenght of time for the list.
It's possible to set up a conditional value list (this is not conditional formatting) using an unstored calculation field that returns today's date:
cToday could be defined to return Get ( CurrentDate )
Then you can use cToday in your value list's relationship.
Forum Tutorial: Custom Value List?
Knowledgebase article: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional%20value%20list
Demo File: http://www.4shared.com/file/f8NsU2DJ/ConditionalValueListDemo.html