Don Knecht

Ok, here's more specific info. Each unit is a separate record. A field in each record has the unit's speed. From there, there is a field for Segments 1-32 that is a calculation that figures out if the unit moves on that segment or not, based on the units speed. Different units moving at different speeds will result in, for example, units 2, 4 and 5 moving on segment 5, units 2 and 5 moving on segment 6, units 1 and 4 moving on segment 7, and units 1, 2 and 5 moving on segment 8, etc. Therefore, I have a different list of units moving each segment. What I want to do is have a one page list of all segments, showing who moves in what segment and in what order they move. To do that, I need to calculate in one field which units move, and which unit moves first. Therefore, I will end up with 32 global calculation fields with a text result that shows which units move, and in what order. Does this help? Thanks in advance .....

I am making a database program to automate game turns for a proportional movement game system, and cannot figure how to have FM sort the units moving each turn. Each record is a different unit, saving the unit's speed, information, etc. There are 32 separate moves per turn, with some, none, or all of the units moving during each of the 32 segments. Whether a unit moves depends on its speed, i.e., something moving Speed 32 will move each segment, something moving Speed 16 will move every other segment, something moving Speed 4 will move every eighth segment, etc. I have it set up by a separate field for Segment 1, Segment 2, etc., to calculate whether a unit moves that segement based on its current speed. Each segment, though, the slowest unit will move first, followed by the second slowest, etc. After determining which units move in that segment, what I am looking to do is output a list of the units ***in the order that they move*** (slowest to fastest). Therein is my problem. They are already in the database and a simple sort doesn't work (or I can't get it to work). A summary field doesn't work either as I need to keep it out of Preview Mode so I can maintain interaction with the fields. Can anyone help with a function, string, relation, solution, approach, etc., that can perform this?

Greetings: I am working on a custom comic book database for myself. I have the standard fields involving title, issue number, etc., and am working on summarizing everything via each different comic book title (i.e., a list of each issue per title, and the like). This is where I need help. I have a drop down menu listing the different titles. I would like to make a selection from the drop down menu, then after I make the selection, automatically find all comics under that title, sort them according to number, and then display the list in a certain layout. Using the script I have so far, it works, but after I select the title, I have to click to continue the script, then click again to finish the find. Is there any way I can do this without having to click twice after I make the title selection? Thanks in advance for the help, Don Knecht dhk@kjoneslaw.com