Another thought that may be easier- I could just query the completed orders products and use that to display the current amount availble.
How does that sound?
I think the original method could most efficiently be done in a store procedure, but that is above my pay grade.
Another question - why would the multi record not work if it was on a seperate page?
I know I am rambling - sinus infection and brain feels very large and not very useful
Thanks for the patience Jason