>I have used this extensively in other parts of the app but here one of the main considerations is allowing them to see what trucks are assigned to the various jobs simultaneously. Other than the 20 trucks there is only about 6 other pieces of info that they need to see so getting 20 truck fields on the screen for each job is the real challenge here. Thanks,

What is the relationship between the data tables here? I thought Paul's suggestion was a great one, because I've used that strategy myself, but I am having trouble visualizing how this scenario is so different from the many that I have had to deal with.