1) I attach the dialogue for settings regarding Specify Fields for Value List. I have a value list set to also display values from second field, but to show values only from second field. In doing so, the dialogue dims out the Sort Values Using option so that only the Second Field is selected. I would like to be able to sort by the first field? Can this be done some how?
2) What are the general plus and minuses of using a Value List as opposed to a Table? Assuming that a value list would change from time to time (then a table would be preferable) rather than the same list of items all the time (then a value list would be better). If I use a value list instead of a table, it makes it difficult or impossible to do sub-summary reports based on these values? It seems setting up tables in all or most cases is the best way to go. Any thoughts?
Thanks very much.