I'm a little unclear on the situation with the two detail pages. You say that you could have the same prodid with different inventory id's. Are inventories based on a particular product? I'm not getting this part. Any of the info on your details pages should be filtered out for a single product. There should only be a single set of information for this product, but it may be in more than one table. Please explain a little about the relation of the products and the inventory so I have a better understanding of how these details should work out.