I have a form that I use to copy records and then change a few fields to create a new record. A few fields do not copy one of them is a primary index key. When I try and save the record it gives me an error null primary key error. Do I have to have the field on my form for it to copy? Another possible thought is how do I update the primary key from two of the fields that do copy on the form. The primary key is made up of two fields that are copied then the user makes the changes to these fields, I would like for it to update the primary key before updating the record.
Thanks in advance
Thanks in advance