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??

You can turn on allow creation of record on the parts side of the relationship if you want to directly add it in the portal. Otherwise, have your script go to a layout for the parts and create the new record in there.