search for: unitparts

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 unit and the appropriate number of unitparts for that product as defined by...