InfoPath Dev

I appreciate your input. Unfortunately due to other reasons I cant set it up this way. This obviously makes perfect sense but the extent of the change in the rest of the project this would be unacceptable to the project manager. Is there any way to filter based on the information the way it is. Thanks,  Gav

I have a feeling I am going over old ground here but I have checked numerous posts and they aren't of a great deal of help for what I am trying to do.  I should say at the outset that the project is a change to an existing sharepoint site hence the design. I probably wouldn't do it this way if I was doing it from scratch.  I ...