I have a database that in the main table it shows the product name and product serial number and also shows a portal with the parts that make the product.
This parts come from the parts table. I need a script to add a new part to the product from the portal, but because it is partID related it has to create the next partID number and put it in the portal in the partID field.
I am losing my hair trying???
Any help??