search for: productsitems

Hi All, I''m running into some issues with a fairly complex database structure. I have 4 tables: Products - id - name Productsitems - id - product_id - name Units - id - product_id - serialnumber Unitparts - id - productsitem_id - unit_id - partnumber - serialnumber What I''m attempting to do is to create a page where, after selecting which product I''m entering, I get presented with the data entry for a new...