sorting related lists

[wasted]

I have a value list based on a relationship between two tables accounts and school districts. The field the list is based off of is a calculation. It combines the districts name and id. I need the list to be sorted alphabetically but I can't make it happen. How do I do this? Thanks

[-Queue-]

Have you tried including a second field in the value list definition, that being the related name field, and telling FM to sort based on it? You might also change the calculation to name & "_" & id instead of id & "_" & name?