Sql Error when creating a new record


After the recent updates to Sc I now get an error when trying to create a new record.

When creating a new record the “OrderID” doesn’t get created untill the record is saved and the mySQL creates the auto increment id #.

This error i’m getting has something to do with the “Multi-Upload” field as its looking for the foreign key which is tied to the “OrderID” which hasn’t been created yet in a new record untill its saved.

Like I said I didn’t get this error before but it kinda makes sense because its referencing an Primary key that doesn’t exist for that record yet.

How can I fix this?